* [Comm] postgresql
@ 2006-12-04 19:32 altlinux
2006-12-05 6:36 ` Alex Gorbachenko
2006-12-11 13:10 ` spider
0 siblings, 2 replies; 4+ messages in thread
From: altlinux @ 2006-12-04 19:32 UTC (permalink / raw)
To: ALT Linux Community
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [Comm] postgresql
2006-12-04 19:32 [Comm] postgresql altlinux
@ 2006-12-05 6:36 ` Alex Gorbachenko
2006-12-11 13:10 ` spider
1 sibling, 0 replies; 4+ messages in thread
From: Alex Gorbachenko @ 2006-12-05 6:36 UTC (permalink / raw)
To: community
[-- Attachment #1: Type: text/plain, Size: 226 bytes --]
On Mon, 04 Dec 2006 22:32:10 +0300
altlinux@aaanet.ru wrote:
>Поставил, перезапустил и дальше никак
>Где системная БД?
там же, где и всегда. в template1.
psql template1 postgres.
--
np: SOILWORK - As We Speak
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [Comm] postgresql
2006-12-04 19:32 [Comm] postgresql altlinux
2006-12-05 6:36 ` Alex Gorbachenko
@ 2006-12-11 13:10 ` spider
2006-12-11 16:09 ` Michael Shigorin
1 sibling, 1 reply; 4+ messages in thread
From: spider @ 2006-12-11 13:10 UTC (permalink / raw)
To: ALT Linux Community
altlinux@aaanet.ru wrote:
> 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 -l ?
Что-то мне шепчет, что поскольку в альте postrges в chroot'е живет,
запускать его надо как-то по-другому.
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [Comm] postgresql
2006-12-11 13:10 ` spider
@ 2006-12-11 16:09 ` Michael Shigorin
0 siblings, 0 replies; 4+ messages in thread
From: Michael Shigorin @ 2006-12-11 16:09 UTC (permalink / raw)
To: ALT Linux Community
On Mon, Dec 11, 2006 at 03:10:10PM +0200, spider wrote:
> > [root@localhost root]# psql -U postgres
Помнится, работало su - -s /bin/bash postgres и последующий psql
> Что-то мне шепчет, что поскольку в альте postrges в chroot'е
> живет, запускать его надо как-то по-другому.
Так оно ж к нему как к серверу, а не как к... файлопомойке ходит.
--
---- WBR, Michael Shigorin <mike@altlinux.ru>
------ Linux.Kiev http://www.linux.kiev.ua/
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2006-12-11 16:09 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2006-12-04 19:32 [Comm] postgresql altlinux
2006-12-05 6:36 ` Alex Gorbachenko
2006-12-11 13:10 ` spider
2006-12-11 16:09 ` Michael Shigorin
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