Problem accessing database on nodes of a cluster

From: Kashif Riaz <kriaz(at)cs(dot)uno(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: <kriaz(at)cs(dot)uno(dot)edu>
Subject: Problem accessing database on nodes of a cluster
Date: 2004-11-27 03:33:01
Message-ID: 4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello admins,

I am having problems accessing a database on the nodes of a cluster. I am
working on a project that is supposed to distribute data on the nodes of a
beowulf cluster and then run queries in parallel on the nodes.

I am able to create and access a database on the master node. But when I
try to access the database on a slave node, I get the following error:

psql: FATAL: database "db001", OID 1198223, has disappeared from pg_database
[1]+ Exit 1 postmaster -p 9012 -D
/home/gayatri/postgres/data >logfile27 2>&1

I would really appreciate any help in this matter.

Thank you.

Sincerely,
Kashif Riaz

The log is given below:

********** ON THE MASTER NODE **********

gayatri(at)plundar:~$ postmaster -p 9012 -D /home/gayatri/postgres/data
>logfileP 2>&1 &
[1] 10114

gayatri(at)plundar:~$ cat logfileP
LOG: could not create IPv6 socket: Address family not supported by protocol
LOG: database system was interrupted at 2004-11-26 21:10:07 CST
LOG: checkpoint record is at 0/2704D208
LOG: redo record is at 0/2704D208; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 1325173; next OID: 1198222
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/2704D248
LOG: redo is not required

gayatri(at)plundar:~$ createdb -p 9012 db001
CREATE DATABASE

********** ON THE SLAVE NODE **********

gayatri(at)plundar:~$ rlogin gumbo27

gayatri(at)gumbo27:~$ postmaster -p 9012 -D /home/gayatri/postgres/data
>logfile27 2>&1 &

gayatri(at)gumbo27:~$ cat logfile27
LOG: could not create IPv6 socket: Address family not supported by protocol
LOG: database system was interrupted at 2004-11-26 20:53:57 CST
LOG: checkpoint record is at 0/2704709C
LOG: redo record is at 0/2704709C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1325169; next OID: 1198222
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/270470DC
LOG: redo is not required
LOG: database system is ready

gayatri(at)gumbo27:~$ psql -p 9012 db001
psql: FATAL: database "db001", OID 1198223, has disappeared from pg_database
[1]+ Exit 1 postmaster -p 9012 -D
/home/gayatri/postgres/data >logfile27 2>&1

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2004-11-27 04:15:30 Re: high (or at least improved) availability and failover
Previous Message Alexis Rigal 2004-11-25 20:33:48 starting pg_ctl or postmaster under WIN2000