From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Message-ID: <457477BA.4080903@aaanet.ru> Date: Mon, 04 Dec 2006 22:32:10 +0300 From: "altlinux@aaanet.ru" User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: ALT Linux Community Content-Type: text/plain; charset=KOI8-R; format=flowed X-Virus-Scanned: ClamAV using ClamSMTP Content-Transfer-Encoding: quoted-printable Subject: [Comm] postgresql X-BeenThere: community@lists.altlinux.org X-Mailman-Version: 2.1.9rc1 Precedence: list Reply-To: ALT Linux Community List-Id: ALT Linux Community List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Dec 2006 19:32:29 -0000 Archived-At: List-Archive: List-Post: alt24 =F0=CF=D3=D4=C1=D7=C9=CC, =D0=C5=D2=C5=DA=C1=D0=D5=D3=D4=C9=CC =C9 =C4=C1= =CC=D8=DB=C5 =CE=C9=CB=C1=CB =E7=C4=C5 =D3=C9=D3=D4=C5=CD=CE=C1=D1 =E2=E4? [root@localhost root]# service postgresql start Adjusting environment for=20 postgresql: = =20 [ DONE ] Creating default=20 database: = =20 [ DONE ] Starting postmaster=20 service: = =20 [ DONE ] Link postgresql=20 socket: = =20 [ 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=20 -r /var/lib/pgsql-root 26401 ? S 0:00 postgres: stats buffer=20 process =20 26415 ? S 0:00 postgres: stats collector=20 process =20 [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 =20 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 =20 16640 16648 16656 16671 17070 17080 17090 PG_VERSION 1249 16390 16402 16414 16601 16607 16613 16619 16629 16635 =20 16641 16649 16658 16673 17072 17082 17092 1255 16392 16404 16416 16602 16608 16614 16620 16630 16636 =20 16642 16650 16659 16674 17074 17084 17094 1259 16394 16406 16418 16603 16609 16615 16621 16631 16637 =20 16643 16651 16661 16676 17075 17085 17095 16384 16396 16408 16595 16604 16610 16616 16624 16632 16638 =20 16644 16652 16665 16680 17077 17087 17097 16386 16398 16410 16597 16605 16611 16617 16625 16633 16639 =20 16647 16653 16667 16682 17079 17089 17099 /var/lib/pgsql/data/base/17141: 1247 16388 16400 16412 16599 16606 16612 16618 16626 16634 =20 16640 16648 16656 16671 17070 17080 17090 PG_VERSION 1249 16390 16402 16414 16601 16607 16613 16619 16629 16635 =20 16641 16649 16658 16673 17072 17082 17092 pg_internal.init 1255 16392 16404 16416 16602 16608 16614 16620 16630 16636 =20 16642 16650 16659 16674 17074 17084 17094 1259 16394 16406 16418 16603 16609 16615 16621 16631 16637 =20 16643 16651 16661 16676 17075 17085 17095 16384 16396 16408 16595 16604 16610 16616 16624 16632 16638 =20 16644 16652 16665 16680 17077 17087 17097 16386 16398 16410 16597 16605 16611 16617 16625 16633 16639 =20 16647 16653 16667 16682 17079 17089 17099 /var/lib/pgsql/data/global: 1260 1261 1262 16622 16623 16627 16628 16645 16646 16662 =20 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 =20 ESTABLISHED 26395/postmaster =20 unix 3 [ ] DGRAM 120387=20 30157/syslogd /var/spool/postfix/dev/log unix 2 [ ACC ] STREAM LISTENING 185720=20 26395/postmaster /tmp/.s.PGSQL.5432