Skip site navigation (1) Skip section navigation (2)

Re: Upgrading to 8.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bill house <wchouse(at)bellsouth(dot)net>
Cc: psql-novice Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Upgrading to 8.4
Date: 2010-02-22 02:29:11
Message-ID: 3460.1266805751@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
bill house <wchouse(at)bellsouth(dot)net> writes:
> root on pts/5 barney2.test.lcl:/usr/local/pgsql
> # l
> total 78656
> drwxr-xr-x  7 root     root         4096 2010-02-21 19:14 .
> drwxr-xr-x 13 root     root         4096 2010-02-21 17:12 ..
> -rw-r--r--  1 postgres postgres      467 2010-02-21 19:08 .bash_profile
> drwxr-xr-x  2 root     root         4096 2010-02-21 17:13 bin
> drwx------ 11 postgres root         4096 2010-02-21 18:09 data
> drwxr-xr-x  6 root     root         4096 2010-02-21 17:13 include
> drwxr-xr-x  3 root     root         4096 2010-02-21 17:13 lib
> -rw-r--r--  1 postgres postgres 80419764 2010-02-21 19:26 
>     		                                             pg_dumpall_20100219.sql
> -rw-r--r--  1 postgres postgres       14 2010-02-21 19:17 .psql_history
> drwxr-xr-x  7 root     root         4096 2010-02-21 17:13 share

Not sure how you got into that state, but having postgres' home
directory owned by root isn't a particularly good idea.  The same
statement would apply for any non-root account.

> 1) Is is necessary/wise/secure to have postgres' home directory the 
> working area of the server? If not, what is a recommended alternative
> home?

The data directory can be anywhere as long as it's owned by the postgres
user.

> 2) After the installation, the owner/group of these files should be?

See above.

> 3) Is there a startup script for inclusion in /etc/init.d contained in 
> the source code package? If so which is it?

You can look in contrib/start-scripts, but that script is pretty crude.
In most cases it would be better to borrow the postgres start script
used by whatever distro you're on.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: dipti shahDate: 2010-02-22 10:56:16
Subject: What is unsecure postgres languages? How to disable them?
Previous:From: bill houseDate: 2010-02-22 02:15:54
Subject: Upgrading to 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group