Re: PG on zeta 1.0 - Mailing list pgsql-novice
| From | kmh496 |
|---|---|
| Subject | Re: PG on zeta 1.0 |
| Date | |
| Msg-id | 1148142197.7568.8.camel@var.sirfsup.com Whole thread Raw |
| In response to | PG on zeta 1.0 ("sam karush" <sk418@rivah.net>) |
| Responses |
Re: PG on zeta 1.0
|
| List | pgsql-novice |
2006-05-20 (토), 11:53 -0400, Tom Lane 쓰시길: > "sam karush" <sk418@rivah.net> writes: > > $ ./postmaster -D /boot/home/database > > LOG: could not translate host name "localhost", service "5432" to address:= > > unknown name or service > > WARNING: could not create listen socket for "localhost" > > FATAL: could not create any TCP/IP sockets > > It looks to me like you don't have DNS correctly configured on that > machine. Every machine should be able to resolve "localhost" as > "127.0.0.1" --- that's standard. Look at name resolution settings, > /etc/resolv.conf, that sort of thing. > > (BTW, what in the heck is "zeta"? I don't think it's really BeOS; > we dropped support for that thing several PG versions back.) wow! i have the same problem. Everything was fine, then i got this email and everything went wacko. coincidence? i think it's the port for an unknown reason. I don't have any port number listed for 5543 but it gives me the same error when i try to use it. If I use port 55543 however there is no problem. I will show below how i started first one postmaster on one cluster, then tried to start another postmaster on another cluster using a different port, and the resulting error (same as sam's), then stopped that second postmaster (it still started, yes), and restarted without the error message on a much higher port (55543): ================================================= [postgres@www ~]$ [postgres@www ~]$ ps -aux | grep pos Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.5/FAQ root 7119 0.0 0.1 5588 1120 pts/4 S 01:04 0:00 su - postgres postgres 7120 0.0 0.1 4384 1452 pts/4 S 01:04 0:00 -bash postgres 7321 0.0 0.0 4484 920 pts/4 R+ 01:08 0:00 ps -aux postgres 7322 0.0 0.0 3756 692 pts/4 R+ 01:08 0:00 grep pos [postgres@www ~]$ pg_ctl -D pg8 start postmaster starting [postgres@www ~]$ LOG: database system was shut down at 2006-05-21 01:08:00 KST LOG: checkpoint record is at 1/28F3484 LOG: redo record is at 1/28F3484; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 7315086; next OID: 11726686 LOG: database system is ready [postgres@www ~]$ ps -aux | grep pos Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.5/FAQ root 7119 0.0 0.1 5588 1120 pts/4 S 01:04 0:00 su - postgres postgres 7120 0.0 0.1 4384 1452 pts/4 S 01:04 0:00 -bash postgres 7329 0.4 0.2 16972 2644 pts/4 S 01:08 0:00 /usr/local/pg8/bin/postmaster -D pg8 postgres 7331 0.0 0.2 16972 2684 pts/4 S 01:08 0:00 postgres: writer process postgres 7332 0.0 0.1 7824 1648 pts/4 S 01:08 0:00 postgres: stats buffer process postgres 7333 0.0 0.1 7032 1764 pts/4 S 01:08 0:00 postgres: stats collector process postgres 7344 0.0 0.3 17396 3248 pts/4 S 01:08 0:00 postgres: mod_log main 127.0.0.1(60566) idle postgres 7345 0.0 0.3 17396 3248 pts/4 S 01:08 0:00 postgres: mod_log main 127.0.0.1(60567) idle postgres 7346 0.0 0.3 17396 3248 pts/4 S 01:08 0:00 postgres: mod_log main 127.0.0.1(60568) idle postgres 7347 0.0 0.3 17396 3248 pts/4 S 01:08 0:00 postgres: mod_log main 127.0.0.1(60569) idle postgres 7348 0.0 0.3 17368 3252 pts/4 S 01:08 0:00 postgres: mod_log main 127.0.0.1(60570) idle postgres 7350 0.0 0.3 17368 3756 pts/4 S 01:08 0:00 postgres: surfer main [local] idle postgres 7352 0.0 0.3 17368 3692 pts/4 S 01:08 0:00 postgres: surfer main [local] idle postgres 7356 0.0 0.3 17368 3692 pts/4 S 01:08 0:00 postgres: surfer main [local] idle postgres 7357 0.0 0.3 17368 3692 pts/4 S 01:08 0:00 postgres: surfer main [local] idle postgres 7358 0.0 0.3 17368 3692 pts/4 S 01:08 0:00 postgres: surfer main [local] idle postgres 7372 0.0 0.0 4484 916 pts/4 R+ 01:09 0:00 ps -aux postgres 7373 0.0 0.0 3756 684 pts/4 R+ 01:09 0:00 grep pos [postgres@www ~]$ pg_ctl -D /bup/pgsql/mod -o "-p5543 -h/bup/pgsql/mod" start postmaster starting [postgres@www ~]$ LOG: could not translate host name "/bup/pgsql/mod", service "5543" to address: Name or service not known WARNING: could not create listen socket for "/bup/pgsql/mod" LOG: database system was shut down at 2006-05-21 01:08:21 KST LOG: checkpoint record is at 0/A251F0 LOG: redo record is at 0/A251F0; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 492; next OID: 17228 LOG: database system is ready[postgres@www ~]$ pg_ctl -D mod -p5543 start pg_ctl: Another postmaster may be running. Trying to start postmaster anyway. sh: 5543: command not found pg_ctl: cannot start postmaster Examine the log output [postgres@www ~]$ [postgres@www ~]$ [postgres@www ~]$ pg_ctl -D mod -p55543 start pg_ctl: Another postmaster may be running. Trying to start postmaster anyway. sh: 55543: command not found pg_ctl: cannot start postmaster Examine the log output [postgres@www ~]$ pg_ctl -D mod -o "-p55543" start pg_ctl: Another postmaster may be running. Trying to start postmaster anyway. FATAL: lock file "/bup/pgsql/mod/postmaster.pid" already exists HINT: Is another postmaster (PID 7381) running in data directory "/bup/pgsql/mod"? pg_ctl: cannot start postmaster Examine the log output [postgres@www ~]$ ls mod/ base global pg_clog pg_hba.conf pg_ident.conf pg_subtrans pg_tblspc PG_VERSION pg_xlog postgresql.conf postmaster.opts postmaster.pid [postgres@www ~]$ cat mod/postmaster.pid 7381 /bup/pgsql/mod 5543001 4096012 [postgres@www ~]$ ps -aux | grep 7381 Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.5/FAQ postgres 7381 0.0 0.2 18168 2752 pts/4 S 01:09 0:00 /usr/local/pg8/bin/postmaster -D /bup/pgsql/mod -p5543 -h/bup/pgsql/mod [postgres@www ~]$ pg_ctl -D mod -p5543 stop LOG: received smart shutdown request LOG: shutting down waiting for postmaster to shut down....LOG: database system is shut down done postmaster stopped [postgres@www ~]$ pg_ctl -D mod -o "-p55543" start postmaster starting [postgres@www ~]$ LOG: database system was shut down at 2006-05-21 01:13:40 KST LOG: checkpoint record is at 0/A2522C LOG: redo record is at 0/A2522C; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 492; next OID: 17228 LOG: database system is ready
pgsql-novice by date: