postgres logfile

Hello all,

I can't start postgresql and logs are empty. Here is the complete steps I did so far:

I just installed Opensuse 11.2, got it up to date. Then I zypped in postgresql and postgresql-server.

When I first did rcpostgresql start, after a while (a minute or so of waiting) I got a message "could not start server". Bummer.

What are the permissions for /var/lib/pgsql? A fresh yum install of postgresql-server sets the directory and all subdirs to postgres:postgres 700. I believe all files in /var/lib/pgsql/data after... [by Winter]

I'm trying to use Postgres on a Mac. After changing the location of the data folder, postgres didnt start. It doesnt give any error message.

I've copied the data folder from another location, and I've tried running

./pg_ctl -D location -l logfile start

from the directory where pg_ctl is located.

I am running postgresql but with every system reboot, the symbolic link /tmp/.s.PGSQL.5432 gets deleted so I have to manually create it through

sudo ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432

and only then postgres start. Is there anyway I can automate this (say the command running at the time system starts) ? also why this /tmp link for postgres ?

This happened after i modified the pg_hba.conf file. It is currently set on trust but the server still asks for a password (even tho when clicking properties the password field is disabled ) . I treied restarting and now the damn thing wont start at all (the server that is; i have no postgres processes now). I also installed postgres 9.0 now and it works .

I start postgresql server from Services menu, pg_ctl.exe launches,then postgres.exe launches and file postmaster.pid is created in data folder.

Then however postgres.exe exits for some reason (I cant find a trace in pg_log folder of a problem) and pid file gets deleted.

So it doesn't start.

Any ideas how I can fix this?

Edit: see comment for answer.

I have an interesting question. On my OS X 10.8 server postgres is running fine.

Launchd has is loaded under the label 'org.postgresql.postgres' and '# launchctl list org.postgresql.postgres' gives the output I expected.

The problem is: I cant find the configuration file. In /S/L/LaunchDeamons and in /L/LaunchDeamons I only have an 'org.postgresql.postgres_alt.plis

I'm trying to install enkompass 3.0 on windows server 2008 x64 standart and each time I try to install it, it ends up with tis error:

Calling custom action PostgreSQLActions!PostgreSQLActions.CustomActions.SetupPostgresSQL Beginning SetupPostgresSQL Postgresql directory, C:\Program Files (x86)\cPanel\postgres\pgsql-8.4\bin, does not exist. Unzipping C:\Program Files (x86)\cPanel\postgres\p

Context:

I'm automatically installing postgresql-9.1 on an Ubuntu server with apt-get. This creates the required postgres user.

The Postgres data is on an external volume that survives reinstalls. This data is obviously owned by the postgres user.

The problem I'm having is that the ownership is not recorded under the name postgres, but under the UID that postgres had at creation time.