mandrake automatically creates the postgres db/cluster in
/var/lib/pgsql/data and automatically starts the db/cluster.
what changes would one need to do if wanting to change the installation of
the db/cluster (e.g. to /var/db/postgres/data)?
would the following suffice?
-stop the postgres service
-delete /var/lib/pgsql/data
-set the PGDATA env to /var/db/postgres/data in /etc/profile
-initdb -D /var/db/postgres/data
-restart the postgres service
also, must a "postgres" user account be created when setting up a new
db/cluster using initdb? can any user account be used? if so, what
settings/permissions (if any) must be changed?
thanks.
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com