[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: how to start postgresql server at machine startup?



[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

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.

> 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


Reply to: