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 <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
Import Notes
Reply to msg id not found: MessagefromLamarOwenlamar.owen@wgcr.orgofTue12Dec2000162528EST.3A3697C8.970B794B@wgcr.org | Resolved by subject fallback
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