Re: [GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-20 Thread Steve Langlois
> On Jul 20, 2016, at 8:03 PM, John R Pierce wrote: > > On 7/20/2016 4:48 PM, Steve Langlois wrote: >> I am upgrading an existing system running CentOS 5.6 with Postgres 8.2.5 to >> CentOS 7 with 9.2.15. The original system modified the postgresql script to >> man

Re: [GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-20 Thread Steve Langlois
On Jul 20, 2016, at 7:48 PM, Steve Langlois mailto:steve.langl...@tavve.com>> wrote: you never did answer my previous question, why are you messing about with manually starting postgres from the wrong user account, when it should be run as a system service with systemctl ? I am upgrad

Re: [GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-20 Thread Steve Langlois
you never did answer my previous question, why are you messing about with manually starting postgres from the wrong user account, when it should be run as a system service with systemctl ? I am upgrading an existing system running CentOS 5.6 with Postgres 8.2.5 to CentOS 7 with 9.2.15. The orig

Re: [GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-20 Thread Steve Langlois
Steve Langlois writes: > I ran > + /usr/bin/initdb --pgdata=/usr/xxx/databases/pgsql/data --auth=ident > without issue however when I try to start the database it complains about the > lockfile. > FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock&qu

Re: [GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-19 Thread Steve Langlois
>Presumably, you are working with a distro-modified version of Postgres, >because the stock sources don't use /var/run/postgresql as a socket >directory. You will likely find that your version of libpq.so also >expects /var/run/postgresql as the socket directory, so you won't be >able to make non

[GENERAL] Re: Is it possible to control the location of the lock file when starting postgres?

2016-07-19 Thread Steve Langlois
My apologies but I didn't include the command I am using to start the database /usr/bin/postmaster -p 5432 -D /usr//databases/pgsql/data FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied Thank you.

[GENERAL] Is it possible to control the location of the lock file when starting postgres?

2016-07-19 Thread Steve Langlois
Using Postgres 9.2 with CentOS7. I ran + /usr/bin/initdb --pgdata=/usr/xxx/databases/pgsql/data --auth=ident without issue however when I try to start the database it complains about the lockfile. FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied

Re: [GENERAL] postgresql "init script" for postgres 9.2.15

2016-07-13 Thread Steve Langlois
aver Sent: Wednesday, July 13, 2016 5:11:24 PM To: Steve Langlois; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgresql "init script" for postgres 9.2.15 On 07/13/2016 01:56 PM, Steve Langlois wrote: > > Hi, I've been searching for a 9.2.15 version of the postgresq

[GENERAL] postgresql "init script" for postgres 9.2.15

2016-07-13 Thread Steve Langlois
Hi, I've been searching for a 9.2.15 version of the postgresql script for "init script for starting up the PostgreSQL". I have managed to find older versions than what we are currently using, 8.2.5 but haven't had any luck finding a new version in the postgres 9.2.15 rpms. We are moving from Ce