ALT Linux Community general discussions
 help / color / mirror / Atom feed
From: "altlinux@aaanet.ru" <altlinux@aaanet.ru>
To: ALT Linux Community <community@lists.altlinux.org>
Subject: [Comm] postgresql
Date: Mon, 04 Dec 2006 22:32:10 +0300
Message-ID: <457477BA.4080903@aaanet.ru> (raw)

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



             reply	other threads:[~2006-12-04 19:32 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2006-12-04 19:32 altlinux [this message]
2006-12-05  6:36 ` Alex Gorbachenko
2006-12-11 13:10 ` spider
2006-12-11 16:09   ` Michael Shigorin

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=457477BA.4080903@aaanet.ru \
    --to=altlinux@aaanet.ru \
    --cc=community@lists.altlinux.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

ALT Linux Community general discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
		mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
	public-inbox-index community

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.community


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git