Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

RedHat Enterprise Server 3.0 32 Bits

psql (PostgreSQL) 8.2.3

user: postgres

server is running:

/soft/postgres/8.2.3/bin/pg_ctl start
pg_ctl: another server may be running; trying to start server anyway
2013-05-09 11:23:07 BRST---:FATAL:  lock file "postmaster.pid" already exists
2013-05-09 11:23:07 BRST---:HINT:  Is another postmaster (PID 12810) running in data directory "/opt/psql/dba/bdadms/data1/pstg"?
pg_ctl: could not start server
Examine the log output.

I had just created a new database cluster with initdb; but when I run createdb:

8.2.3:postgres:pstg:>/soft/postgres/8.2.3/bin/createdb pstg
createdb: could not connect to database postgres: FATAL:  could not write init file
8.2.3:postgres:pstg:>/soft/postgres/8.2.3/bin/createdb postgres
createdb: could not connect to database template1: FATAL:  could not write init file
8.2.3:postgres:pstg:>/soft/postgres/8.2.3/bin/createdb template1
createdb: could not connect to database postgres: FATAL:  could not write init file

any clues as to the cause and possible solutions to this problem?

share|improve this question
What distribution of Linux are you using, and how did you install PostgreSQL? That path looks very non-standard, and 8.2 is an extremely old release. – IMSoP May 9 at 14:14
Did you start the service? – Clodoaldo May 9 at 14:25
@IMSoP I didn't install anything, this is a legacy server; I must create a new cluster. Linux distro is Red Hat 3.0. – Lynx Kepler May 9 at 19:18
@Clodoaldo Neto yes. – Lynx Kepler May 9 at 19:19
According to the messages you posted the server is not running: pg_ctl: could not start server Delete the .pid file. – Clodoaldo May 9 at 19:23
show 3 more comments

migrated from stackoverflow.com May 10 at 14:08

1 Answer

up vote 0 down vote

Check for disk space usage or see if the permissions are properly laid out on data directories.

share|improve this answer
298MB free. drwxrwxr-x 3 postgres postgres whoami postgres – Lynx Kepler May 10 at 13:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.