On Wed, Oct 29, 2008 at 8:27 AM, Star Liu <[EMAIL PROTECTED]> wrote: > 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 & > ----------- In the ~/log/logfile file, i found the error message says cannot find postgres command, so i change it to this: su -c "/usr/lib/postgresql/8.3/bin/postgres -D ~/data > ~/log/logfile 2>&1 &" postgres and it works now!
>>> 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.] > -- 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.]
