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

[ario <..hidden..>]

On Thu, 5 Dec 2013 15:43:37 -0800
Chris Travers <..hidden..> wrote:

> 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

Thanks,

ario


> > >
> > > >
> > > >
> > > >
> > > >
> > > > 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
> >
> 
> 
> 


------------------------------------------------------------------------------
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