Thara Vadakkeveedu wrote:
ps –edf shows no postgres processes:
-bash-4.1$ ps -edf | grep postgres
root 6412 6249 0 18:22 pts/000:00:00 su - postgres
postgres 6413 6412 0 18:22 pts/000:00:00 -bash
postgres 6465 6413 1 18:27 pts/000:00:00 ps -edf
postgres 6466 6413
Here are the settings in the postgresql.conf file:
I remember turning on logging to troubleshoot a performance issue
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
#log_filename = 'postgresql-%a.log'
This is what I find in pg_log/postgresql-Mon.log file (contents relate to my
attempts to start postgres yesterday)
LOG: database system was shut down at 2013-09-22 12:20:51 EDT
LOG: invalid magic number in log file 0, segment 39, offset 0
LOG: invalid primary checkpoint record
LOG:
Thank you!
I deleted data directory again and then ran initdb.
This time service started successfully.
TG
From: Albe Laurenz laurenz.a...@wien.gv.at
To: Thara Vadakkeveedu thar...@yahoo.com; pgsql-admin@postgresql.org
pgsql-admin@postgresql.org
Sent:
Hi
I am trying to connect to the database on a linux server from pgadmin on my
windows desktop.
I see Error connecting to the server: Fatal: password authentication failed
for user postgres
I specified my linux server name for the host
port : 5432
Maintenance DB : postgres
username:postgres
I need to create a database and a user and make this new user the owner of this
new database.
Since I cannot access postgres db from pgadmin client on my desktop,
I tried to do the same from the command line on the linux db server:
su - postgres
-bash-4.1$ psql -d postgres
postgres=#