Re: PG on zeta 1.0

2006-05-20 (토), 11:53 -0400, Tom Lane 쓰시길:
> "sam karush" <sk418(at)rivah(dot)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(at)www ~]$
[postgres(at)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(at)www ~]$ pg_ctl -D pg8 start
postmaster starting
[postgres(at)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(at)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(at)www ~]$ pg_ctl -D /bup/pgsql/mod -o "-p5543
-h/bup/pgsql/mod" start
postmaster starting
[postgres(at)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(at)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(at)www ~]$
[postgres(at)www ~]$
[postgres(at)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(at)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(at)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(at)www ~]$ cat mod/postmaster.pid
7381
/bup/pgsql/mod
5543001 4096012
[postgres(at)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(at)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(at)www ~]$ pg_ctl -D mod -o "-p55543" start
postmaster starting
[postgres(at)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