pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kashif Riaz <kriaz@cs.uno.edu>
To: pgsql-admin@postgresql.org
Cc: kriaz@cs.uno.edu
Subject: Problem accessing database on nodes of a cluster
Date: Fri, 26 Nov 2004 21:33:01 -0600 (CST)
Message-ID: <4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu> (raw)

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@plundar:~$ postmaster -p 9012 -D /home/gayatri/postgres/data
>logfileP 2>&1 &
[1] 10114

gayatri@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@plundar:~$ createdb -p 9012 db001
CREATE DATABASE


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

gayatri@plundar:~$ rlogin gumbo27

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

gayatri@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@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











view thread (2+ messages)  latest in thread

Message-ID: <4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu>
Permalink:  ../4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu/
Also on:    postgresql.org/message-id/4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kriaz@cs.uno.edu
  Subject: Re: Problem accessing database on nodes of a cluster
  In-Reply-To: <4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu>
  References: <4355.137.30.122.67.1101526381.squirrel@mailport.cs.uno.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox