After I upgraded to Core 4 the Postgresql service does not start. I now know that major upgrades kill Postgrsql..
My question is can I save the data I have in their now? I cannot do a pg_dump as the DB wont start.
I do not have a current dump file to use..
Anybody have ideas?
\Bob
On 5/25/06, Bob Ambroso bambroso@gmail.com wrote:
After I upgraded to Core 4 the Postgresql service does not start. I now know that major upgrades kill Postgrsql..
My question is can I save the data I have in their now? I cannot do a pg_dump as the DB wont start.
I do not have a current dump file to use..
Anybody have ideas?
So you're saying that you've never backed up or dumped the DB?
Lonni J Friedman wrote:
On 5/25/06, Bob Ambroso bambroso@gmail.com wrote:
that major upgrades kill Postgrsql..
My question is can I save the data I have in their now? I cannot do a pg_dump as the DB wont start.
I do not have a current dump file to use..
So you're saying that you've never backed up or dumped the DB?
Copy your /var/lib/pgsql directory to somewhere safe.
Try installing pgsql on an FC3 computer (or whatever older version you were upgrading from). Copy the /var/lib/pgsql contents to it, and maybe (!) you'll have a functional database again. Maybe not, though.
Do you have pre-upgrade tape (or CD or whatever) backups of the /var/lib/pgsql directory? Those files would be better than the post-upgrade ones.
I too learned about Fedora's habit of clobbering pgsql data after upgrades the hard way... but I had enough backups to fix things. Backup your raw files AND do a pgdumpall every night!
- Mike
I did as you instructed... Installed FC2 on another computer did a filesystem backup of the "upgraded" data folder and moved it to the new/old FC2 system. Performed a cursory configuration on the 7.4 postgres and then I un-tarred the backup into the data folder. Started up the postgres server and got no errors. I performed the pg_dumpall and moved the dumpall.dmp file to the "upgraded" or 8.x system. Now I am really in a loop because I cannot restore the dump file unless the server is running but it will not run because the data format is different.. I would assume I have to nuke the thing back to bare bones and then create the old databases and then perform a restore.... Does this sound right??
Sheesh...
Thanks for any help.. \Bob
On 5/25/06, Dr. Michael J. Chudobiak mjc@avtechpulse.com wrote:
Lonni J Friedman wrote:
On 5/25/06, Bob Ambroso bambroso@gmail.com wrote:
that major upgrades kill Postgrsql..
My question is can I save the data I have in their now? I cannot do a pg_dump as the DB wont start.
I do not have a current dump file to use..
So you're saying that you've never backed up or dumped the DB?
Copy your /var/lib/pgsql directory to somewhere safe.
Try installing pgsql on an FC3 computer (or whatever older version you were upgrading from). Copy the /var/lib/pgsql contents to it, and maybe (!) you'll have a functional database again. Maybe not, though.
Do you have pre-upgrade tape (or CD or whatever) backups of the /var/lib/pgsql directory? Those files would be better than the post-upgrade ones.
I too learned about Fedora's habit of clobbering pgsql data after upgrades the hard way... but I had enough backups to fix things. Backup your raw files AND do a pgdumpall every night!
- Mike
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
It is a test server. I normally use MYSQL and it was a test app that required Postgresql.. It is test data.. Quite alot actually but to answer your question.. No.. I blindly upgraded (have done so in the past with MYSQL) and now it is hose and I assume my test dat is as well...
\BOb
On 5/25/06, Lonni J Friedman netllama@gmail.com wrote:
On 5/25/06, Bob Ambroso bambroso@gmail.com wrote:
After I upgraded to Core 4 the Postgresql service does not start. I now
know
that major upgrades kill Postgrsql..
My question is can I save the data I have in their now? I cannot do a pg_dump as the DB wont start.
I do not have a current dump file to use..
Anybody have ideas?
So you're saying that you've never backed up or dumped the DB?
--
L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org -- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote:
It is a test server. I normally use MYSQL and it was a test app that required Postgresql.. It is test data.. Quite alot actually but to answer your question.. No.. I blindly upgraded (have done so in the past with MYSQL) and now it is hose and I assume my test dat is as well...
---- postgresql does not update it's db files. They are most likely not hosed but rather still in earlier format. If you can move them to another computer using the same version of postgresql that you were using, you should be able to then pg_dump all the data and them load it into the newer version. That is the way postgresql has always worked.
You should be regularly 'dumping' your data from any sql db as a backup whether it is mysql, postgresql or ???
You should be backing up your data prior to any OS 'upgrade'
I did the same thing myself in upgrading Fedora Core 2 to Fedora Core 4 but I did have a pg_dump file that was a few days old.
;-)
Craig
Can you tell me how to do a pg_dump when the server wont start? It complains about data in an earlier format... Tar up data directory and move it???
Any help is appreciated..
\Bob
On 5/25/06, Craig White craigwhite@azapple.com wrote:
On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote:
It is a test server. I normally use MYSQL and it was a test app that required Postgresql.. It is test data.. Quite alot actually but to answer your question.. No.. I blindly upgraded (have done so in the past with MYSQL) and now it is hose and I assume my test dat is as well...
postgresql does not update it's db files. They are most likely not hosed but rather still in earlier format. If you can move them to another computer using the same version of postgresql that you were using, you should be able to then pg_dump all the data and them load it into the newer version. That is the way postgresql has always worked.
You should be regularly 'dumping' your data from any sql db as a backup whether it is mysql, postgresql or ???
You should be backing up your data prior to any OS 'upgrade'
I did the same thing myself in upgrading Fedora Core 2 to Fedora Core 4 but I did have a pg_dump file that was a few days old.
;-)
Craig
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Yes, you have to move the data onto a system that has the same version of postgresql - tarball is fine. Then you ***may*** have to remove/reinstall postgresql-server to get the base data files installed.
Craig
On Thu, 2006-05-25 at 19:36 -0700, Bob Ambroso wrote:
Can you tell me how to do a pg_dump when the server wont start? It complains about data in an earlier format... Tar up data directory and move it???
Any help is appreciated..
\Bob
On 5/25/06, Craig White craigwhite@azapple.com wrote: On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote: > It is a test server. I normally use MYSQL and it was a test app that > required Postgresql.. It is test data.. Quite alot actually but to > answer your question.. No.. I blindly upgraded (have done so in the > past with MYSQL) and now it is hose and I assume my test dat is as > well... ---- postgresql does not update it's db files. They are most likely not hosed but rather still in earlier format. If you can move them to another computer using the same version of postgresql that you were using, you should be able to then pg_dump all the data and them load it into the newer version. That is the way postgresql has always worked.
You should be regularly 'dumping' your data from any sql db as a backup whether it is mysql, postgresql or ??? You should be backing up your data prior to any OS 'upgrade' I did the same thing myself in upgrading Fedora Core 2 to Fedora Core 4 but I did have a pg_dump file that was a few days old. ;-) Craig -- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
I did as you instructed... Installed FC2 on another computer did a filesystem backup of the "upgraded" data folder and moved it to the new/old FC2 system. Performed a cursory configuration on the 7.4 postgres and then I un-tarred the backup into the data folder. Started up the postgres server and got no errors. I performed the pg_dumpall and moved the dumpall.dmp file to the "upgraded" or 8.x system. Now I am really in a loop because I cannot restore the dump file unless the server is running but it will not run because the data format is different.. I would assume I have to nuke the thing back to bare bones and then create the old databases and then perform a restore.... Does this sound right??
How do I take the upgraded postgres server back to bare bones.. initdb again??
Sheesh... they sure dont make it easy... Not that I did anything to make it so... ;-)
Thanks for any help..
On 5/25/06, Craig White craigwhite@azapple.com wrote:
Yes, you have to move the data onto a system that has the same version of postgresql - tarball is fine. Then you ***may*** have to remove/reinstall postgresql-server to get the base data files installed.
Craig
On Thu, 2006-05-25 at 19:36 -0700, Bob Ambroso wrote:
Can you tell me how to do a pg_dump when the server wont start? It complains about data in an earlier format... Tar up data directory and move it???
Any help is appreciated..
\Bob
On 5/25/06, Craig White craigwhite@azapple.com wrote: On Thu, 2006-05-25 at 19:12 -0700, Bob Ambroso wrote: > It is a test server. I normally use MYSQL and it was a test app that > required Postgresql.. It is test data.. Quite alot actually but to > answer your question.. No.. I blindly upgraded (have done so in the > past with MYSQL) and now it is hose and I assume my test dat is as > well... ---- postgresql does not update it's db files. They are most likely not hosed but rather still in earlier format. If you can move them to another computer using the same version of postgresql that you were using, you should be able to then pg_dump all the data and them load it into the newer version. That is the way postgresql has always worked.
You should be regularly 'dumping' your data from any sql db as a backup whether it is mysql, postgresql or ??? You should be backing up your data prior to any OS 'upgrade' I did the same thing myself in upgrading Fedora Core 2 to Fedora Core 4 but I did have a pg_dump file that was a few days old. ;-) Craig -- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
-- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
On 6/6/06, Bob Ambroso bambroso@gmail.com wrote:
I did as you instructed... Installed FC2 on another computer did a filesystem backup of the "upgraded" data folder and moved it to the new/old FC2 system. Performed a cursory configuration on the 7.4 postgres and then I un-tarred the backup into the data folder. Started up the postgres server and got no errors. I performed the pg_dumpall and moved the dumpall.dmp file to the "upgraded" or 8.x system. Now I am really in a loop because I cannot restore the dump file unless the server is running but it will not run because the data format is different.. I would assume I have to nuke the thing back to bare bones and then create the old databases and then perform a restore.... Does this sound right??
How do I take the upgraded postgres server back to bare bones.. initdb again??
Delete the contents of /var/lib/pgsql, then "service postgres start", and then import the DB dump.
it worked.. Thanks for taking the time and you can bet I will become very intimate with the pg_dump command set!
Take care...
\Bob
On 6/6/06, Lonni J Friedman netllama@gmail.com wrote:
On 6/6/06, Bob Ambroso bambroso@gmail.com wrote:
I did as you instructed... Installed FC2 on another computer did a filesystem backup of the "upgraded" data folder and moved it to the
new/old
FC2 system. Performed a cursory configuration on the 7.4 postgres and
then I
un-tarred the backup into the data folder. Started up the postgres
server
and got no errors. I performed the pg_dumpall and moved the dumpall.dmpfile to the "upgraded" or 8.x system. Now I am really in a loop because I
cannot
restore the dump file unless the server is running but it will not run because the data format is different.. I would assume I have to nuke the thing back to bare bones and then create the old databases and then
perform
a restore.... Does this sound right??
How do I take the upgraded postgres server back to bare bones.. initdb again??
Delete the contents of /var/lib/pgsql, then "service postgres start", and then import the DB dump.
--
L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org -- fedora-list mailing list fedora-list@redhat.com To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
On Thu, May 25, 2006 at 07:12:27PM -0700, Bob Ambroso wrote:
It is a test server. I normally use MYSQL and it was a test app that required Postgresql.. It is test data.. Quite alot actually but to answer your question.. No.. I blindly upgraded (have done so in the past with MYSQL) and now it is hose and I assume my test dat is as well...
\BOb
You might be able to find an RPM of the postgress version that matches your database and install that using "rpm --oldpackage -Uvh" and that would allow you to get the database back up and dump it out.
-
Bob Ambroso -
Craig White -
Dr. Michael J. Chudobiak -
Kayvan A. Sylvan -
Lonni J Friedman