postmaster does not start up
От | Andrew Perrin - Demography |
---|---|
Тема | postmaster does not start up |
Дата | |
Msg-id | Pine.SUN.4.10.10012050937520.22579-100000@davis.DEMOG.Berkeley.EDU обсуждение исходный текст |
Ответы |
Re: [GENERAL] postmaster does not start up
Re: [GENERAL] postmaster does not start up |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: