From: | Lord Voldemort <murderthemuggles(at)yahoo(dot)co(dot)in> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Help me start postmaster on a default installation of PostgreSQL. |
Date: | 2011-07-06 10:34:55 |
Message-ID: | 4E143A4F.50104@yahoo.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi!
I'm running Ubuntu 10.10 and I have installed PostgreSQL and JDBC
drivers form the repository. I have not changed any default settings. I
want to run the postmaster service to access database from a Java
program. I've read around a bit about and it has not helped. I don't
want to go in great depth about how to do this because right now I'm
focusing on learning Java and I don't really have enough time to read
hundreds of pages of docs.
I've added /usr/lib/postgresql/8.4/bin to my PATH variable.
Command "pg_ctl start" or "postmaster" gives an error about not being
able to find "postgresql.conf" in the directory specified by PGDATA or
my home folder if it's blank.
I found this file (postgresql.con) in /etc/postgresql/8.4/main/ and
created a shortcut to it in my home folder.
Now I'm getting error
2011-07-06 09:56:57 GMT FATAL: data directory
"/var/lib/postgresql/8.4/main" has wrong ownership
2011-07-06 09:56:57 GMT HINT: The server must be started by the user
that owns the data directory.
This data directory is owned by postgres.
I read somewhere that this postmaster has to be run by the user postgres
but I don't know how to do that.
Apart from that my installation is working fine. I've already created a
user for myself and a small trial database too.
Please help me.
From | Date | Subject | |
---|---|---|---|
Next Message | ml-tb | 2011-07-06 15:45:38 | Re: Old bug reappeared: JDBC driver: getIndexInfo() returns quotes around quoted column names |
Previous Message | Rob Gansevles | 2011-07-05 15:15:25 | Old bug reappeared: JDBC driver: getIndexInfo() returns quotes around quoted column names |