Discussion:
lost database
(too old to reply)
Jodi Kanter
2003-12-09 16:12:15 UTC
Permalink
I am working with someone who has been running creating and maintaining
his own database. He somehow managed to blow away his database and needs
to restore. However, he has not been running regular dumps because he
figured the tape backups were enough.
Is there anyway that I can assist him in retreiving his tables from
backup tapes? I am not sure how or where that data is stored.
Thanks
Jodi Kanter
--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
***@virginia.edu <mailto:***@virginia.edu>/



/ /

/ /
Kris Kiger
2003-12-09 16:35:28 UTC
Permalink
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any ideas?
Thanks for the help

Kris


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
Peter Eisentraut
2003-12-09 16:44:47 UTC
Permalink
Post by Kris Kiger
Is there a way to force a shared object to reload? I've compiled a
new version of a .so, but postgres seems to be pulling the old
version out of memory. I've tried deleting the .so and recompiling
it, but postgres is insistant, for some reason, of using the old
version. Any ideas? Thanks for the help
Use the LOAD command or just restart the session.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Glenn Wiorek
2003-12-09 16:55:02 UTC
Permalink
Is it a postgres shared object only? Then shuting down and restarting
postgres should have worked. If it is a OS shared object then my best guess
is postgres will see it already in memory and not reload the object/lib. In
which case you will need to bounce the OS. Is it possible another program
is also using that object? Then shuting that program down also and
restarting postgres may do the trick.

One thing though, if the OS or another program is also using that shared
object isn't there a risk to having a newer version being loaded by postgres
affect other things?


----- Original Message -----
From: "Kris Kiger" <***@musicrebellion.com>
To: "Postgres Admin List" <pgsql-***@postgresql.org>
Sent: Tuesday, December 09, 2003 10:35 AM
Subject: [ADMIN] Postgres grabbing an old shared object
Post by Kris Kiger
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any ideas?
Thanks for the help
Kris
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
Joe Conway
2003-12-09 17:16:49 UTC
Permalink
Post by Kris Kiger
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any ideas?
Thanks for the help
See the LOAD command:
http://www.postgresql.org/docs/current/static/sql-load.html

Joe


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Peter Eisentraut
2003-12-09 16:44:12 UTC
Permalink
Post by Jodi Kanter
Is there anyway that I can assist him in retreiving his tables from
backup tapes? I am not sure how or where that data is stored.
Tell us more about how the backup was made, then we can tell you more
about how to restore it.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Jodi Kanter
2003-12-09 17:17:37 UTC
Permalink
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists. I am trying to determine what
particular files need to be retrieved in order to restore the database
as it existed yesterday. Is this possible?
Thanks for the assistance.
Jodi
Post by Peter Eisentraut
Post by Jodi Kanter
Is there anyway that I can assist him in retreiving his tables from
backup tapes? I am not sure how or where that data is stored.
Tell us more about how the backup was made, then we can tell you more
about how to restore it.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
***@virginia.edu <mailto:***@virginia.edu>/



/ /

/ /
Peter Eisentraut
2003-12-09 17:18:55 UTC
Permalink
Post by Jodi Kanter
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists.
That was the missing piece of information.
Post by Jodi Kanter
I am trying to determine what
particular files need to be retrieved in order to restore the
database as it existed yesterday. Is this possible?
Thanks for the assistance.
Shut down the server if still running, put back the entire data
directory (probably /var/lib/pgsql in your case), and start the server.
Partial restoration is not possibly from file system backup.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly
Joe Conway
2003-12-09 17:19:34 UTC
Permalink
Post by Jodi Kanter
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists. I am trying to determine what
particular files need to be retrieved in order to restore the database
as it existed yesterday. Is this possible?
Thanks for the assistance.
Restore the entire $PGDATA directory. If this is a default Red Hat
system that would be something like /var/lib/pgsql/data

HTH,

Joe



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Naomi Walker
2003-12-09 21:30:26 UTC
Permalink
I'm assuming you are using pg_dumpall for your backups. In that case, i'd
restore the instance somewhere else, and pg_dump the one database.
Post by Jodi Kanter
I am working with someone who has been running creating and maintaining
his own database. He somehow managed to blow away his database and needs
to restore. However, he has not been running regular dumps because he
figured the tape backups were enough.
Is there anyway that I can assist him in retreiving his tables from backup
tapes? I am not sure how or where that data is stored.
Thanks
Jodi Kanter
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
-------------------------------------------------------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc.
***@eldocomp.com 602-604-3100
-------------------------------------------------------------------------------------------------------------------------
Never eat more than you can lift. - Miss Piggy
------------------------------------------------------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
Loading...