Thread: postmaster does not start up
Greetings - this is with a newly-compiled 7.0.3 under debian 2.2 on a pentium box. All compiling went just fine; however, although the postmaster is running based on ps, it can't be accessed. Any ideas will be much appreciated. postgres@nujoma:~$ declare -x PGDATA="/var/lib/postgres/data" postgres@nujoma:~$ ls /var/lib/postgres/data PG_VERSION pg_geqo.sample pg_hba.conf pg_xlog base pg_group pg_log postmaster.opts pg_control pg_group_name_index pg_shadow postmaster.opts.default pg_database pg_group_sysid_index pg_variable postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl start postmaster successfully started up. postgres@nujoma:~$ DEBUG: Data Base System is starting up at Tue Dec 5 12:37:46 2000 DEBUG: Data Base System was shut down at Mon Dec 4 13:48:41 2000 DEBUG: Data Base System is in production state at Tue Dec 5 12:37:46 2000 postgres@nujoma:~$ postgres@nujoma:~$ psql Connection to database 'template1' failed. connectDB() -- connect() failed: Connection refused Is the postmaster running at 'localhost' and accepting connections on Unix socket '5432'? postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl status pg_ctl: postmaster is running (pid: 1775) options are: /usr/local/pgsql/bin/postmaster -p 5432 -D /var/lib/postgres/data -B 64 -b /usr/local/pgsql/bin/postgres -N 32 postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl stop Smart Shutdown request at Tue Dec 5 12:38:01 2000 postmaster successfully shut down. DEBUG: Data Base System shutting down at Tue Dec 5 12:38:01 2000 DEBUG: Data Base System shut down at Tue Dec 5 12:38:01 2000 postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl -w start Waiting for postmaster starting up...DEBUG: Data Base System is starting up at Tue Dec 5 12:38:06 2000 DEBUG: Data Base System was shut down at Tue Dec 5 12:38:01 2000 DEBUG: Data Base System is in production state at Tue Dec 5 12:38:06 2000 ............................................................pg_ctl: postmaster does not start up postgres@nujoma:~$ ps aux | grep postmaster postgres 1816 0.0 1.0 4280 996 pts/4 S 12:38 0:00 /usr/local/pgsql/bin/postmaster postgres 2005 0.0 0.4 1108 404 pts/4 S 12:41 0:00 grep postmaster --------------------------------------------------------------------- Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support Department of Demography - University of California at Berkeley 2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
Andrew Perrin - Demography wrote: >Greetings - this is with a newly-compiled 7.0.3 under debian 2.2 on a ... >postgres@nujoma:~$ psql >Connection to database 'template1' failed. >connectDB() -- connect() failed: Connection refused >Is the postmaster running at 'localhost' and accepting connections on Unix >socket '5432'? If you have package libpgsql2 installed, get rid of it; or compile from the Debian source. Because of conflict with other packages, the location of the Unix socket is now different in Debian. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Be of good courage, and he shall strengthen your heart, all ye that hope in the LORD." Psalms 31:24
Andrew Perrin - Demography <aperrin@demog.Berkeley.EDU> writes:
> Greetings - this is with a newly-compiled 7.0.3 under debian 2.2 on a
> pentium box. All compiling went just fine; however, although the
> postmaster is running based on ps, it can't be accessed. Any ideas will be
> much appreciated.
> postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl start
> postgres@nujoma:~$ psql
> Connection to database 'template1' failed.
> connectDB() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost' and accepting connections on Unix
> socket '5432'?
Hmm. Where are you invoking psql from, and is it the same one you
compiled yourself?
ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix
socket file, which means that an RPM psql will NOT talk to a standard
compilation of the postmaster, nor vice versa.
I've complained about that packaging choice in the past ;-)
regards, tom lane
Tom Lane wrote: > Hmm. Where are you invoking psql from, and is it the same one you > compiled yourself? > ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix > socket file, which means that an RPM psql will NOT talk to a standard > compilation of the postmaster, nor vice versa. Um, the Debian packages are .deb's, not RPM's. Is the standard socket location not /tmp? That's where the RPM's put it. I don't know about the DEB's -- ask Oliver. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Lamar Owen wrote: >Tom Lane wrote: >> Hmm. Where are you invoking psql from, and is it the same one you >> compiled yourself? > >> ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix >> socket file, which means that an RPM psql will NOT talk to a standard >> compilation of the postmaster, nor vice versa. > >Um, the Debian packages are .deb's, not RPM's. Is the standard socket >location not /tmp? That's where the RPM's put it. I don't know about >the DEB's -- ask Oliver. No. /var/run/postgresql - it was necessary to move them, because long-open sockets were being deleted from /tmp (it is, after all, a _temporary_ directory) by tmpreaper. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "For thou art my hope, O Lord GOD; thou art my trust from my youth." Psalms 71:5
> Lamar Owen wrote: > >Tom Lane wrote: > >> Hmm. Where are you invoking psql from, and is it the same one you > >> compiled yourself? > > > >> ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix > >> socket file, which means that an RPM psql will NOT talk to a standard > >> compilation of the postmaster, nor vice versa. > > > >Um, the Debian packages are .deb's, not RPM's. Is the standard socket > >location not /tmp? That's where the RPM's put it. I don't know about > >the DEB's -- ask Oliver. > > No. /var/run/postgresql - it was necessary to move them, because long-open > sockets were being deleted from /tmp (it is, after all, a _temporary_ > directory) by tmpreaper. /var/run seems like a good spot for it. How do you make sure clients see it? Do you have a symlink in /tmp? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026