Re: how to start postgresql server at machine startup?
On Wed, Oct 29, 2008 at 8:27 AM, Star Liu <minxinjianxin@gmail.com> wrote:
> On Wed, Oct 29, 2008 at 5:54 AM, Chris Bannister
> <mockingbird@earthlight.co.nz> 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!
>>
>> root@box:~# 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
>
>> root@box:~# 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 debian-user-REQUEST@lists.debian.org
>> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>>
>>
>
>
>
> --
> 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) starliu@live.com (xmpp) minxinjianxin@gmail.com
> 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) starliu@live.com (xmpp) minxinjianxin@gmail.com
HomePage http://starliu dot 9966 dot com [It's only available when my
personal machine is running, on which it's hosted.]
Reply to: