[Comm] postgresql
=?iso-8859-1?q?altlinux_=CE=C1_aaanet=2Eru?=
=?iso-8859-1?q?altlinux_=CE=C1_aaanet=2Eru?=
Пн Дек 4 22:32:10 MSK 2006
alt24
Поставил, перезапустил и дальше никак
Где системная БД?
[root на localhost root]# service postgresql start
Adjusting environment for
postgresql:
[ DONE ]
Creating default
database:
[ DONE ]
Starting postmaster
service:
[ DONE ]
Link postgresql
socket:
[ DONE ]
[root на localhost root]# psql -U postgres
psql: FATAL: database "postgres" does not exist
[root на localhost root]# ps ax | grep post
1958 ? S 0:02 /usr/lib/postfix/master
26395 ? S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data -S
-r /var/lib/pgsql-root
26401 ? S 0:00 postgres: stats buffer
process
26415 ? S 0:00 postgres: stats collector
process
[root на localhost root]# ls -R /var/lib/pgsql/data/
/var/lib/pgsql/data/:
PG_VERSION base global pg_clog pg_hba.conf pg_ident.conf pg_xlog
postgresql.conf postmaster.opts postmaster.pid
/var/lib/pgsql/data/base:
1 17141
/var/lib/pgsql/data/base/1:
1247 16388 16400 16412 16599 16606 16612 16618 16626 16634
16640 16648 16656 16671 17070 17080 17090 PG_VERSION
1249 16390 16402 16414 16601 16607 16613 16619 16629 16635
16641 16649 16658 16673 17072 17082 17092
1255 16392 16404 16416 16602 16608 16614 16620 16630 16636
16642 16650 16659 16674 17074 17084 17094
1259 16394 16406 16418 16603 16609 16615 16621 16631 16637
16643 16651 16661 16676 17075 17085 17095
16384 16396 16408 16595 16604 16610 16616 16624 16632 16638
16644 16652 16665 16680 17077 17087 17097
16386 16398 16410 16597 16605 16611 16617 16625 16633 16639
16647 16653 16667 16682 17079 17089 17099
/var/lib/pgsql/data/base/17141:
1247 16388 16400 16412 16599 16606 16612 16618 16626 16634
16640 16648 16656 16671 17070 17080 17090 PG_VERSION
1249 16390 16402 16414 16601 16607 16613 16619 16629 16635
16641 16649 16658 16673 17072 17082 17092 pg_internal.init
1255 16392 16404 16416 16602 16608 16614 16620 16630 16636
16642 16650 16659 16674 17074 17084 17094
1259 16394 16406 16418 16603 16609 16615 16621 16631 16637
16643 16651 16661 16676 17075 17085 17095
16384 16396 16408 16595 16604 16610 16616 16624 16632 16638
16644 16652 16665 16680 17077 17087 17097
16386 16398 16410 16597 16605 16611 16617 16625 16633 16639
16647 16653 16667 16682 17079 17089 17099
/var/lib/pgsql/data/global:
1260 1261 1262 16622 16623 16627 16628 16645 16646 16662
16664 16668 16670 16677 16679 pg_control pgstat.stat
/var/lib/pgsql/data/pg_clog:
0000
/var/lib/pgsql/data/pg_xlog:
0000000000000000
[root на localhost root]# netstat -pan | grep post
udp 0 0 127.0.0.1:32779 127.0.0.1:32779
ESTABLISHED 26395/postmaster
unix 3 [ ] DGRAM 120387
30157/syslogd /var/spool/postfix/dev/log
unix 2 [ ACC ] STREAM LISTENING 185720
26395/postmaster /tmp/.s.PGSQL.5432
Подробная информация о списке рассылки community