dear all
we have the following issues and cannot start the
postgresql server:
postgresql 8.0.5
redhat EL WS4 U3
the computer was shutdown properly. then the user
restarted the computer, in the middle of rebooting, he
switched off the power button on the wall. after that
we cannot start the
dear all
can any one recommend a good postgresql training
course in the UK. thanks
cheng
=
Best wishes
Z C Wang
___ALL-NEW Yahoo! Messenger -
so many all-new ways to express yourself
hi,
the man page says pg_dump cannot dump large objects.
can some one help me on what does this realy mean? how
large is large? if we have some icons can we still use
pg_dumpall to backup the db?
also large objects do not include large strings,
right?
thanks
cheng
=
Best wishes
Z C Wang
, zhicheng
wang wrote:
hi,
i can see the file 1259 is there and the db
apparently
working normal and can be started/stopped OK.
if your tool cannot work on this set of db, does
it
mean that the db is problematic? i am realy
worried.
thanks in advance for advice.
cheng
,
maybe strace it to
see where it's going wrong.
Hope this helps,
On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng
wang wrote:
hi,
has any one used Martijn van Oosterhout's
PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?
i ran
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:
hi,
has any one used Martijn van Oosterhout's PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?
i ran this again my database and it gives this error:
Couldn't find relation pg_class(1259)
does any one know what this is about
cheng
=
Best wishes
,
maybe strace it to
see where it's going wrong.
Hope this helps,
On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng
wang wrote:
hi,
has any one used Martijn van Oosterhout's
PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?
i ran
can any one tell me about the meaning of
pg_xlog/0F1
pg_xlog/0F2
pg_xlog/0F3
pg_xlog/0F4
..
pg_xlog/0F8
is the
pg_xlog/000
missing
thanks
chneg
=
Best wishes
Z C Wang
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
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 the failed
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
please help
cheng
--- Richard Huxton [EMAIL PROTECTED] wrote:
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
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
14 matches
Mail list logo