it may be not that bad - thanks to Martijn van
Oosterhout's tool, we can recover all the tables apart
from three which type could not be recognised.
this was a test db. but i have learnt a lot and also
have a feel of the seriousness if the real thing
broken.
Thanks to every one and i hope that no
=?iso-8859-1?q?zhicheng=20wang?= <[EMAIL PROTECTED]> writes:
> in case it is useful to any one. the db server uses
> san to store the data. the update is only to the bios
> of the fibre card. if this is wrong, many other files
> should also go wrong, which is not the case.
What you should be looki
sorry for the late reply
in case it is useful to any one. the db server uses
san to store the data. the update is only to the bios
of the fibre card. if this is wrong, many other files
should also go wrong, which is not the case.
cheng
--- Tom Lane <[EMAIL PROTECTED]> wrote: >
=?iso-8859-1?q?zh
Hi,
the /var/log/pgsql is empty
but on this message log, what is "rhdb: ^[[60G["?
i do not see this before
thanks
cheng
--- Richard Huxton <[EMAIL PROTECTED]> wrote: >
zhicheng wang wrote:
> > Hi Richard Huxton
> >
> > below is the rhdb part of the shutdown log
> >
> > any indications for t
zhicheng wang wrote:
Hi Richard Huxton
below is the rhdb part of the shutdown log
any indications for the failed restart?
thanks
cheng
May 28 15:43:37 sanlinux rhdb: Stopping PostgreSQL -
Red Hat Edition service:
May 28 15:43:37 sanlinux su(pam_unix)[12400]: session
opened for user postgres by
Hi Richard Huxton
below is the rhdb part of the shutdown log
any indications for the failed restart?
thanks
cheng
May 28 15:43:37 sanlinux rhdb: Stopping PostgreSQL -
Red Hat Edition service:
May 28 15:43:37 sanlinux su(pam_unix)[12400]: session
opened for user postgres by (uid=0)
May 28 15:4
Dear Richard
it was not a crash. we issued poweroff command, then
we used a dos floppy to upgrade bios on the fibrecard.
then when we reboot into the redhat AS3, the rhdb
could not start.
the log is attached.
after using pg_resetxlog, we cannot see our db, only
template0/1 listed by psql -l
ple
zhicheng wang wrote:
dear all
after we shutdown the rh_postgres-server 7.3.6, rhdb
could not start. we tried
pg_resetxlog -f PGDATA
then the server can be started, but only template0 and
template1 db available.
our database not listed.
Was there a crash?
What do your logs say?
How much d
dear all
after we shutdown the rh_postgres-server 7.3.6, rhdb
could not start. we tried
pg_resetxlog -f PGDATA
then the server can be started, but only template0 and
template1 db available.
our database not listed.
please any help
thanks
cheng
_
