Greetings,
In short:
Using a new FreeBSD (4.9) PostgreSQL (7.3) server, can I
rescue PostgreSQL data from a hard drive pulled from an
older (motherboard just died) FreeBSD (4.??) PostgreSQL (7.??)
server? If so, how?
The long version:
Helping a friend who had a FreeBSD PostgreSQL server crash recently.
This was a motherboard failure, and the data on the drives looks
usable, but we are rebuilding the server, using a newer PostgreSQL
(7.3) - his most recent PostgreSQL dump was a few weeks ago,
(hey, at least he was backing it up - sort of). The version of
PostgreSQL used to build his data is unknown - whatever was current
around August of 2002 (7.1 maybe?). (Once the server is built and
the old drive mounted, I may be able to figure out the exact version
from the FreeBSD package DB, which should also be on that drive.)
Normally, I would tell him to just run with the dump from a couple
of weeks ago and live with it, but there has been a lot of non-
duplicable work done since then by an individual who left his
organization 2 days ago (and apparently cursed his server when
she left ;-) )
It would be real nice if we could use one of the old server drives
to restore his PostgreSQL DB - without having to build an old
PostgreSQL server just to extract the data, then rebuild on a 7.3
server.
Is this feasible? Pits or tipfalls, anyone?
Cheers and many thanks,
Conrad
6  2015 
On Fri, Dec 19, 2003 at 12:43:24AM +0000, Conrad wrote:
It would be real nice if we could use one of the old server drives
to restore his PostgreSQL DB - without having to build an old
PostgreSQL server just to extract the data, then rebuild on a 7.3
server.
Is this feasible? Pits or tipfalls, anyone?
No. You need the old server.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<an****@liberty rms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
Conrad <bo***********@ nospam.com> writes: Helping a friend who had a FreeBSD PostgreSQL server crash recently.
This was a motherboard failure, and the data on the drives looks
usable, but we are rebuilding the server, using a newer PostgreSQL
(7.3) - his most recent PostgreSQL dump was a few weeks ago,
(hey, at least he was backing it up - sort of). The version of
PostgreSQL used to build his data is unknown - whatever was current
around August of 2002 (7.1 maybe?). (Once the server is built and
the old drive mounted, I may be able to figure out the exact version
from the FreeBSD package DB, which should also be on that drive.)
The PG_VERSION files in the data directory will give you the major
version (e.g. 7.1), and you can use any server in that major version
series --- though of course you should always use the latest minor
release in the series ;-)
You will need to use some version in the same series; a newer major
release will *not* start up.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I think you're going to have to build an old PG. But really, how long
does that take, an hour maybe on a slow machine? Just install it to a
non-standard directory and you'll be fine.
In fact, on second thought, you should find out what version of PG he was
using, and stick to that. You really shouldn't upgrade PG versions
(especially major versions, but minor versions as well) without running
your own tests.
Jon
On Fri, 19 Dec 2003, Conrad wrote:
Greetings,
In short:
Using a new FreeBSD (4.9) PostgreSQL (7.3) server, can I
rescue PostgreSQL data from a hard drive pulled from an
older (motherboard just died) FreeBSD (4.??) PostgreSQL (7.??)
server? If so, how?
The long version:
Helping a friend who had a FreeBSD PostgreSQL server crash recently.
This was a motherboard failure, and the data on the drives looks
usable, but we are rebuilding the server, using a newer PostgreSQL
(7.3) - his most recent PostgreSQL dump was a few weeks ago,
(hey, at least he was backing it up - sort of). The version of
PostgreSQL used to build his data is unknown - whatever was current
around August of 2002 (7.1 maybe?). (Once the server is built and
the old drive mounted, I may be able to figure out the exact version
from the FreeBSD package DB, which should also be on that drive.)
Normally, I would tell him to just run with the dump from a couple
of weeks ago and live with it, but there has been a lot of non-
duplicable work done since then by an individual who left his
organization 2 days ago (and apparently cursed his server when
she left ;-) )
It would be real nice if we could use one of the old server drives
to restore his PostgreSQL DB - without having to build an old
PostgreSQL server just to extract the data, then rebuild on a 7.3
server.
Is this feasible? Pits or tipfalls, anyone?
Cheers and many thanks,
Conrad
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
On Fri, 19 Dec 2003 00:43:24 +0000, Conrad wrote:
Greetings,
In short:
Using a new FreeBSD (4.9) PostgreSQL (7.3) server, can I
rescue PostgreSQL data from a hard drive pulled from an
older (motherboard just died) FreeBSD (4.??) PostgreSQL (7.??)
server? If so, how?
The long version:
[drop table rest_of_message]
Many thanks, all - 7.2.1 (the version that was on the old
machine building as we speak. Do I need to do the full
initbd, or can I just slide the old data/ tree in place?
Thanks,
Conrad
The world rejoiced as Conrad <bo***********@ nospam.com> wrote: On Fri, 19 Dec 2003 00:43:24 +0000, Conrad wrote:
Greetings,
In short:
Using a new FreeBSD (4.9) PostgreSQL (7.3) server, can I
rescue PostgreSQL data from a hard drive pulled from an
older (motherboard just died) FreeBSD (4.??) PostgreSQL (7.??)
server? If so, how?
The long version:
[drop table rest_of_message]
Many thanks, all - 7.2.1 (the version that was on the old
machine building as we speak. Do I need to do the full
initbd, or can I just slide the old data/ tree in place?
The first thing to try certainly is to "slide the old data tree into
place." I'd suggest keeping a scratch copy, of course...
It ought to "just work." Indeed, it ought to "just work" if you put
7.2.4 software in place.
--
output = ("cbbrowne" "@" "ntlug.org" ) http://cbbrowne.com/info/multiplexor.html
But what can you do with it? -- ubiquitous cry from Linux-user
partner. -- Andy Pearce, <aj*@hpopd.pwd. hp.com>
On Fri, 19 Dec 2003, Jonathan Bartlett wrote: I think you're going to have to build an old PG. But really, how long
does that take, an hour maybe on a slow machine? Just install it to a
non-standard directory and you'll be fine.
FYI, on the slowest computer I own, pgsql 7.2 took 30 minutes to run
../configure and 2.5 hours to run make / make install. that machine is a
486DX250 laptop (Toshiba 4700) with 16 Megs of RAM. A 50 MHz Sparc 20
with SCSI drives took about half that time.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: My Internet |
last post by:
Hello,
I am in the process to define if our product can use PostgreSQL.
Do you know what type of application use PostgreSQL, and also what is the
size of the database for these projects?
Our application has a table with more than 300000 rows. There are complexe
query with many joins. And we must respect some time constraints. Also the
application is running 24 hours per day, so the product must be stable, with
|
by: Carmen Wai |
last post by:
Hello:
I would like to know whether there is any different in installing Postgresql
on the Linux system with file system of EXT2 or EXT3. I have two machines
with idential OS (Red Hat 7.3 install with postgresql 7.3.4) but with
different file system, 1 is EXT2 and the other is EXT3. When I insert 10,000
records to the two machines, I found that the machine with EXT2 insert much
quicker than the other with EXT3.
Is postgresqk perform...
|
by: Paul Ganainm |
last post by:
Hi all,
Following up on another thread, here is a comparison between FB and PG
from an FB'ers POV. BTW, FB is the love-child of Open-Source-Interbase.
BTW, I have tried to be as accurate as I can with the information
available to me at this point in time - I was unable to find anything
resembling a feature list on the FB site, so most of this is from
memory. I do have an email account on the various lists on that site,
and I will post...
|
by: Froggy / Froggy Corp. |
last post by:
Thx for your quick answer too :)
Richard Huxton wrote:
>
> On Wednesday 18 February 2004 20:18, Froggy / Froggy Corp. wrote:
> > Hello,
> >
> > I asked one time for more "benchmark" soft to know where is the cpu
> > average, and read the post about optimising the postgresql.conf (and use
> > them), but i allways get a load > 1 on fire time (dunno the right name,
|
by: Anthony |
last post by:
Our Database is having errors. We are currently using PostgreSQL to
store 2.5 Million records per day. The average addition to our primary
table is 4.5 Gigs of data.
We are doing this on a dual Opteron 244 system with 1 TeraByte of HDD
space. The drives are 250 Gig Western Digital. The Raid Controller is
LSI Logic MegaRaid 150-6.
We are getting an error after about 4-5 days worth of data being put
into the system.
| | |
by: mike.griffin |
last post by:
My name is Mike Griffin and we are adding PostgreSQL support to our
product, MyGeneration. MyGeneration pulls meta-data from DBMS systems to
generate business objects and stored procedures and such.
We are using the .NET managed provider Npgsql.dll. We typically get meta
data from OleDb providers and they provide good meta, however, there are
none for PostgreSQL that support the meta data services, so we're hitting
system tables. I'm...
|
by: Andy B |
last post by:
If I bought one of these boxes/OS combos as a postgresql database server,
would postgresql be able to make the best use of it with a huge (e.g. 40GB)
database?
Box: HP ProLiant DL585, with 4 AMD64 CPUs and 64GB of RAM. (other
vendor options also exist)
OS: SUSE enterprise 8 linux for AMD
(links to product info at bottom)
|
by: Shelby Cain |
last post by:
I'm putting 8.0 through its paces and here are a few
things I've noticed on the native win32 port running
on my workstation (2.0g p4 w/256 megs of ram).
Here is the output of "vacuum verbose item":
====================
INFO: vacuuming "public.item"
INFO: "item": removed 246381 row versions in 24044
pages
|
by: jptpjs via AccessMonster.com |
last post by:
I have an application I built in Access 2003. It is an electronic medical
records program split into front end (8 computers) and back end.
This runs flawlessly. Purchased a billing program that uses Postgresql.
This resides on the same computer as our Access backend.
We keep getting knocked out of the new billing program and never get knocked
out of my Access program. The billing software provider says that Access and
Postgresql running...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
