How to run PostgreSQL?

Поиск
Список
Период
Сортировка
От Jan Muhammad
Тема How to run PostgreSQL?
Дата
Msg-id 786080.4059.qm@web38704.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: How to run PostgreSQL?
Re: How to run PostgreSQL?
Список pgsql-admin
Hi,

I have just downloaded, installed/configured postgresql version 8.2.11 on Fedora Core 6. While reading through the installation manual have setup most of its parts; now while trying to run datebase server with the command:  
$ postmaster -D /usr/local/pgsql/data

I get the following error:

"FATAL:  data directory "/usr/local/pgsql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700)."

Although I'm running this command from user 'postgres'; who has the ownership of /pgsql/data directories as well.

Secondly, when I try to check that postgresql service is running or not; with the command: # service postgrsql status
postgrsql: unrecognized service

Again when I configured all it stuff, like the following among several things:

[root@callisto]#  cp /usr/local/pgsql/postgresql-8.2.11/contrib/start-scripts/linux /etc/init.d/postgres

[root@callisto init.d]# chmod 755 /etc/init.d/postgres

[root@callisto init.d]# gedit /etc/init.d/postgres

[root@callisto init.d]# ln -s /etc/init.d/postgres /etc/rc2.d/S85postgres

[root@callisto init.d]# ln -s /etc/init.d/postgres /etc/rc3.d/S85postgres

[root@callisto init.d]# /etc/init.d/postgres start

Starting PostgreSQL: ok
I wonder what is the best way to get PostgreSQL working? Any help in this regard will be highly appreciated..

Regards

-Jan Muhammad


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

Предыдущее
От: Michael Monnerie
Дата:
Сообщение: Re: Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?
Следующее
От: Ray Stell
Дата:
Сообщение: Re: How to run PostgreSQL?