Re: PG on zeta 1.0

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