I have installed postgres on f18 x86_64 with the following packages
rpm -qa | grep postgres
postgresql-libs-9.2.2-1.fc18.x86_64
postgresql-server-9.2.2-1.fc18.x86_64
postgresql-9.2.2-1.fc18.x86_64
These are the instructions I could find to setup and start postgres
su -
cd /usr/lib64/pgsql
su postgres
$ initdb -D /var/lib/pgsql/data
$ pg_ctl -D /v
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.
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
I'm trying to setup rails 3.0.10 on a Ubuntu VPS server. I'm using postgres 9.0.4, Apache and passenger.
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 ?
I'm trying to get this command to work as the user postgres (so I can ship wal files):
rsync -a /tmp/test postgres@server2:/tmp/test
But I get the error:
Permission denied (publickey).
I've run ssh-keygen eval `ssh-agent` and ssh-add as postgres user on server1.
I have a database on a hard drive from a computer whose motherboard died. The HD is fine.
I'm trying to XCOPY the data directory and overwrite the contents of a Postgres 8.4 data directory on another computer.
I'm getting Access Denied. I have verified that the Postgres service is stopped. The target computer has 2 user accounts, one of which is "Postgres" which the Postgres install created.
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.
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
Email this page