| 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: | Whole Thread | Raw Message | 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 |