2551/pgdata/digoal/1921/data02/pg_root13318036541921/pgdata/digoal/1921/data02/pg_root0.0.0.01921001 6127619
ps -ewf|grep 2551postgres 2551 1 0 17:27 ? 00:00:00 /opt/pgsql/bin/postgrespostgres 2552 2551 0 17:27 ? 00:00:00 postgres: logger processpostgres 2554 2551 0 17:27 ? 00:00:00 postgres: writer processpostgres 2555 2551 0 17:27 ? 00:00:00 postgres: wal writer processpostgres 2556 2551 0 17:27 ? 00:00:00 postgres: autovacuum launcher processpostgres 2557 2551 0 17:27 ? 00:00:00 postgres: archiver processpostgres 2558 2551 0 17:27 ? 00:00:00 postgres: stats collector process
digoal=# select pg_postmaster_start_time();pg_postmaster_start_time-------------------------------2012-03-15 17:27:34.416047+08(1 row)digoal=# select extract(epoch from '2012-03-15 17:27:34'::timestamp);date_part------------1331803654(1 row)
stat postmaster.pid
File: `postmaster.pid'
Size: 119 Blocks: 8 IO Block: 4096
regular file Device: fd03h/64771d Inode: 1572868 Links: 1
Access: (0600/-rw-------)
Uid: ( 500/postgres)
Gid: ( 500/postgres)
Access: 2012-03-15 17:41:10.416810701 +0800
Modify: 2012-03-15 17:27:34.364810701 +0800
Change: 2012-03-15 17:27:34.364810701 +0800
ipcs------ Shared Memory Segments --------key shmid owner perms bytes nattch status0x001d4fe9 6127619 postgres 600 617250816 4