On Wed, Oct 29, 2008 at 5:54 AM, Chris Bannister <[EMAIL PROTECTED]> wrote: > > [Please don't bottom-post. Instead, remove quoted material that you're > not replying to, and reply inline to the points you're responding to.] > > On Tue, Oct 28, 2008 at 05:26:22PM +0800, Star Liu wrote: >> my /etc/postgresql folder has nothing inside, did i miss some process >> for postgresql server? thanks > > Something is severely hosed! > > [EMAIL PROTECTED]:~# ls -al /etc/postgresql > total 20 > drwxr-xr-x 3 root root 4096 2008-08-31 09:35 . > drwxr-xr-x 108 root root 12288 2008-10-28 23:07 .. > drwxr-xr-x 3 root root 4096 2008-08-31 09:30 8.3 unfortunitely, I do not have the folder 8.3 inside
> [EMAIL PROTECTED]:~# ls -al /etc/postgresql-common/ > total 32 > drwxr-xr-x 3 root root 4096 2008-10-13 12:29 . > drwxr-xr-x 108 root root 12288 2008-10-28 23:07 .. > -rw-r--r-- 1 root root 1999 2008-03-31 22:39 autovacuum.conf > drwxr-xr-x 2 root root 4096 2007-01-30 04:30 pg_upgradecluster.d > -rw-r--r-- 1 root root 540 2007-12-29 00:50 root.crt > -rw-r--r-- 1 root root 1135 2006-04-05 08:52 user_clusters > > I'd do a pg_dump then purge the postgresql packages, reinstall them then > use pg_restore. thank you, I think it should be an available solution. but what i'm curious is how to execute a command as another user? why the following command does not work? --------------- su -c "postgres -D ~/data > ~/log/logfile 2>&1 &" postgres ---------------- for it doesn't work, i need to break this command into 2 seperate commands to make it work, but it's not convinient. ----------- su postgres postgres -D ~/data > ~/log/logfile 2>&1 & ----------- >> I'm a debian user and a web >> developer(XML+XSLT+AJAX+XHTML＋CSS+PostgreSQL+MONO C#) in City of >> Shanghai, China. > > Mmmm, of course, if you have done any heavy customisation on a previous > version then perhaps the upgrade didn't go to smoothly? I'm only > guessing here. > > -- > Chris. > ====== > I contend that we are both atheists. I just believe in one fewer god > than you do. When you understand why you dismiss all the other > possible gods, you will understand why I dismiss yours. > -- Stephen F Roberts > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > > -- I'm a debian user and a web developer(XML+XSLT+AJAX+XHTML＋CSS+PostgreSQL+MONO C#) in City of Shanghai, China. Welcome to add my IMs! (msn) [EMAIL PROTECTED] (xmpp) [EMAIL PROTECTED] HomePage http://starliu dot 9966 dot com [It's only available when my personal machine is running, on which it's hosted.]
