Re: Fw: Postgresql 7 does not always start on RH 6.2

Поиск
Список
Период
Сортировка
От KuroiNeko
Тема Re: Fw: Postgresql 7 does not always start on RH 6.2
Дата
Msg-id 39E98672.nailD011HOVV@ed.ed
обсуждение исходный текст
Ответ на Fw: Postgresql 7 does not always start on RH 6.2  ("Warren Flemmer" <warren@netlab.co.za>)
Список pgsql-general
 Warren,

> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
> start
> >/dev/null 2>&1"


 Something like this:

su -l postgres -c "/usr/bin/og_ctl -D $PGDATA -p /usr/bin/postmaster start
>> /var/log/pgsql 2>&1"

 Then check that  /var/log/pgsql exists and is writeable  by postgres user.
Eg, include pgsql in a group called log, then

# chown root.log /var/log
# chmod 0750 /var/log
# cd /var/log
# echo -n > ./pgsql
# chown postgres.root ./pgsql
# chmod 0600 ./pgsql

 Also, make sure that /var and / are 5 for user postgres.
 Another  reason for  postmaster to  fail is  a stale  UNIX domain  socket,
usually /tmp/.s.PGSQL.5432 It remains in /tmp if for some reason postmaster
hasn't been stopped correctly.

 HTH

 Ed


---
 Well I tried to be meek
  And I have tried to be mild
 But I spat like a woman
  And I sulked like a child
 I have lived behind the walls
  That have made me alone
 Striven for peace
  Which I never have known

 Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)


В списке pgsql-general по дате отправления:

Предыдущее
От: "Warren Flemmer"
Дата:
Сообщение: Fw: Postgresql 7 does not always start on RH 6.2
Следующее
От: zaor@sky.pl (Pawel Zaorski)
Дата:
Сообщение: dissallowing access to databases