| From: | "Andrew J(dot) Kopciuch" <akopciuch(at)bddf(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Service startup - troubleshooting |
| Date: | 2007-02-12 18:31:06 |
| Message-ID: | 200702121131.07077.akopciuch@bddf.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I imagine the configuration was mangled somewhere down the line.
> Perhaps I need to reinstall Ubuntu, though it's not something I look
> forward to (I already tried uninstalling Postgres and wiping away all
> references to it prior to my last install).
>
> Thanks for taking a look!
>
> -------------------------------------------------------------------------
> myuser(at)mycomputer:~$ sudo /etc/init.d/postgresql-8.1 status
> Password:
> Version Cluster Port Status Owner Data
> directory Log file
This shows that you do not have a cluster.
try running
sudo pg_createcluster 8.1 main
> myuser(at)mycomputer:~$ sudo /etc/init.d/postgresql-8.1 start -D /usr/
> local/pgsql/data
sudo /etc/init.d/postgresql-8.1 start
is all you should need. Give that a try first, and the confirm you actually
have a cluster with
sudo /etc/init.d/postgresql-8.1 status
> myuser(at)mycomputer:~$ sudo /etc/init.d/postgresql-8.1 status
> Version Cluster Port Status Owner Data
> directory Log file
> myuser(at)mycomputer:~$ ls -a /var/log/postgresql
> . ..
That seems strange. It appears that your installation is missing something.
What do you get from :
dpkg -l *postgresql*
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Aiken | 2007-02-12 18:38:43 | Re: how to store whole XML file in database |
| Previous Message | Tommy Gildseth | 2007-02-12 18:09:52 | Re: how to store whole XML file in database |