Re: postgresql settings in fedora 18? The power of logic!

On Thu, Dec 5, 2013 at 8:18 AM, ario <..hidden..> wrote:

That's odd, it says:
# Port number for server to listen on
Environment=PGPORT=5432

# Location of database directory
Environment=PGDATA=/var/lib/pgsql/data

Yeah, I am still getting used to systemd ;-).

>
> >
> > Anyway, I leave the rest of the debugging magic to the developers
> > and will try to see if I can get the password straightened out.

By the way, is there a default password for the postgres user?

By default, no password is acceptable. You have to set a password by doing something like this:

sudo su postgres -c psql

then from the psql client:

ALTER USER postgres WITH PASSWORD 'secretpassword';

You may also need to change the pg_hba.conf (also in the PGDATA directory) as per our INSTALL file.

Best Wishes,

Chris Travers

regards,
ario

> >
> > regards,
> > ario
> >
> > P.S. Due to my migration from KVM to Qubes-OS I won't be able to
> > run a CentOS instance anymore, which means that unfortunately I
> > won't be able to submit any CentOS rpm rebuilds anymore. Sorry
> > about that.
> >
>
> No problem. I think we are going to start working on real Fedora
> RPM's (hopefully getting into extras, etc) fairly soon in the hopes
> that we can get into RHEL directly that way.
>
> Best Wishes,
> Chris Travers
>
> >
> >
> >
> >
> > On Thu, 5 Dec 2013 02:52:34 +0000
> > ario <..hidden..> wrote:
> >
> > > Hi, trying to get it working.
> > >
> > > I found a postgresql.conf file in three directories:
> > > /usr/lib/tmpfiles.d/postgresql.conf
> > > /usr/share/pgsql/postgresql.conf.sample
> > > /var/lib/pgsql/data/postgresql.conf
> > >
> > > I guess I don't have to bother about the first one.
> > > The presence of the second (.sample) one suggests this file needs
> > > to be copied (to postgresql.conf) within the same dir and edited
> > > properly.
> > >
> > > Which one is finally used by pgsql,
> > > the /usr/share/pgsql/postgresql.conf or
> > > the /var/lib/pgsql/data/postgresql.conf one?
> > >
> > >
> > >
> > > Especially the 'listen to' entry asks for attention here, as it
> > > says:
> > >
> > > #port = 5432 # (change requires
> > > restart) # Note: In RHEL/Fedora installations, you can't set the
> > > port number here; # adjust it in the service file instead.
> > >
> > > As this is a fedora install I would need to know what 'they' mean
> > > by 'service file'.
> > >
> > >
> > > Was the postgresql.conf file not assumed to be configured during
> > > ledgersmb install? In that case something would have gone wrong
> > > there.
> > >
> > >
> > > regards,
> > > ario
> > >
> > >
> > >
> > >
> > ------------------------------------------------------------------------------
> > > Sponsored by Intel(R) XDK
> > > Develop, test and display web and hybrid apps with a single code
> > > base. Download it for free now!
> > >
> > http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> > > _______________________________________________
> > > Ledger-smb-users mailing list
> > > ..hidden..
> > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
> >
> > ------------------------------------------------------------------------------
> > Sponsored by Intel(R) XDK
> > Develop, test and display web and hybrid apps with a single code
> > base. Download it for free now!
> >
> > http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
>
>
>

------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more.shtml