Thread: postmaster does not start up

postmaster does not start up

From
Andrew Perrin - Demography
Date:
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


Re: [GENERAL] postmaster does not start up

From
"Oliver Elphick"
Date:
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



Re: [GENERAL] postmaster does not start up

From
Tom Lane
Date:
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

Re: Re: [GENERAL] postmaster does not start up

From
Lamar Owen
Date:
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

Re: Re: [GENERAL] postmaster does not start up

From
"Oliver Elphick"
Date:
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



Re: Re: [GENERAL] postmaster does not start up

From
Bruce Momjian
Date:
> 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