dbTalk Databases Forums  

Cluster in users home

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Cluster in users home in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Russell Shaw
 
Posts: n/a

Default Cluster in users home - 01-11-2004 , 11:22 PM






Hi,
I just installed pgsql on debian. Can i have initdb create
the database cluster in my home directory and have it all
owned by russell instead of postgres?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


Reply With Quote
  #2  
Old   
Oliver Elphick
 
Posts: n/a

Default Re: Cluster in users home - 01-12-2004 , 11:32 PM






On Mon, 2004-01-12 at 05:22, Russell Shaw wrote:
Quote:
Hi,
I just installed pgsql on debian. Can i have initdb create
the database cluster in my home directory and have it all
owned by russell instead of postgres?
If you built your own: certainly.

If you installed the Debian package: yes, but the installation assumes a
postmaster running as user postgres and the database cluster in a
system-configured location. You would need to run your own version with
a different port number (not the default, 5432) so as not to conflict
with the system's version. You would also need to make
/usr/lib/postgresql/bin part of your path, since some of the executables
are not linked to /usr/bin because they are assumed to be for the
postgres user only.
--
Oliver Elphick Oliver.Elphick (AT) lfix (DOT) co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Wherefore let him that thinketh he standeth take heed
lest he fall." I Corinthians 10:12


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.