[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