Re: how to start postgresql server at machine startup?
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 &
-----------
>> 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.]
Reply to: