I call initdb with such params
*/opt/PostgreSQL/9.1/bin/initdb -D /projects/data_dir/data -E UTF-8 -U u*ser
after that create pg_log dir when I would create log (but why I must do this
step?)
change hba file and start database server with this command
/*opt/PostgreSQL/9.1/bin/pg_ctl start -w -D
sorry, my mistake when I connect to user I set login to postgres
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4714912.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
Hi!
Can I call initdb with some params as regular user (not root or postgres)?
May I have some problem with replication, backup or with some other
subsystem?
Thank you!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4712980.html
On 08/18/2011 03:20 PM, alexondi wrote:
Hi!
Can I call initdb with some params as regular user (not root or postgres)?
postgres is a normal userso no problem at all.
initdb cannot be run as root
May I have some problem with replication, backup or with some other
subsystem?
Thank you!
--
On tor, 2011-08-18 at 11:20 -0700, alexondi wrote:
Can I call initdb with some params as regular user (not root or postgres)?
Sure.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Sure you can. The initdb command just sets up the directory you
specified and that's all it does. The files in the directory will be
created with that user's permission. So the directory you specify must
be accessible to that regular user.
man page - http://linux.die.net/man/1/initdb
Creating a
I have some single-purpose system and user can interact only with special
software (on computer would start only this software{daemon and gui},
postgresql and other system daemons). And I don't wont change user when I
call psql, pg_ctl, rsync and other stuff.
--
View this message in context:
On Thu, Aug 18, 2011 at 11:59 AM, alexondi alexo...@rambler.ru wrote:
I have some single-purpose system and user can interact only with special
software (on computer would start only this software{daemon and gui},
postgresql and other system daemons). And I don't wont change user when I
call
