Take the 2-minute tour ×
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.

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
    
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 '13 at 14:14
    
Did you start the service? –  Clodoaldo May 9 '13 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 '13 at 19:18
    
@Clodoaldo Neto yes. –  Lynx Kepler May 9 '13 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 '13 at 19:23
show 3 more comments

migration rejected from stackoverflow.com Sep 10 '13 at 10:34

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by dezso, FreshPhilOfSO, Mark Storey-Smith, Chris Travers, ypercube Sep 10 '13 at 10:34

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – dezso, FreshPhilOfSO, Mark Storey-Smith, Chris Travers, ypercube
If this question can be reworded to fit the rules in the help center, please edit the question.