Re: [GENERAL] A question on PSQL 8.3 setup

2009-07-23 Thread Jong Chun Park
Yes, it's working now. I appreciate your help. The problem was to not stoppsql process even before doing anything. Thanks a lot, Jong On Thu, Jul 23, 2009 at 7:38 AM, Sam Mason wrote: > On Thu, Jul 23, 2009 at 01:08:26AM -0600, Jong Chun Park wrote: > > I need to configure PSQL to store all DB-

Re: [GENERAL] A question on PSQL 8.3 setup

2009-07-23 Thread Sam Mason
On Thu, Jul 23, 2009 at 01:08:26AM -0600, Jong Chun Park wrote: > I need to configure PSQL to store all DB-related data into > /home/pgsql/data instead of somewhere in / such as /var/lib/ > postgresql/8.3/... or /usr/local/pgsql/data. Assuming you're using the standard builds in Ubuntu, I'd probab

Re: [GENERAL] A question on PSQL 8.3 setup

2009-07-23 Thread Daniel Verite
Jong Chun Park wrote: > > sudo mkdir /home/pgsql > > sudo mkdir /home/pgsql/data > > sudo chown postgres /home/pgsql/data > > sudo mkdir /home/pgsql/ts > > sudo chown postgres /home/pgsql/ts > > sudo su - postgres > > initdb -D /home/pgsql/data > > pg_ctl -D /home/pgsql/data -l logfile sta

[GENERAL] A question on PSQL 8.3 setup

2009-07-23 Thread Jong Chun Park
Hi, folks? I'm hoping this is the right mailing list for this sort of question. If not, I apologize you any inconvenience in advance, though. I'm trying to set up postgreql 8.3 in a box running Ubuntu 8.04 and PSQL 8.3 Thisbox is sort of misconfigured because it has 15GB for / and 3 TB for /home.