Re: [GENERAL] Disaster recovery (server died)

2009-06-20 Thread Madison Kelly
Uwe C. Schroeder wrote: On Friday 19 June 2009, Scott Marlowe wrote: On Fri, Jun 19, 2009 at 8:43 PM, Miguel Miranda wrote: Well, i just didnt explain in detail, what i have is just the 16897 directory where i was storing the database, i tried just copying the files but it didnt work, should i

Re: [GENERAL] Disaster recovery (server died)

2009-06-20 Thread Alan McKay
On Sat, Jun 20, 2009 at 12:45 AM, Uwe C. Schroeder wrote: > What I don't get is this: you said your CPU died. For me that's the processor > or maybe some interpret that as the main board. > So why don't you grab the harddisk from that server and plug it into the new > one? x 2 Should work fine.

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Uwe C. Schroeder
On Friday 19 June 2009, Scott Marlowe wrote: > On Fri, Jun 19, 2009 at 8:43 PM, Miguel > > Miranda wrote: > > Well, i just didnt explain in detail, what i have is just the 16897 > > directory where i was storing the database, i tried just copying the > > files but it didnt work, > > should it be p

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Scott Marlowe
On Fri, Jun 19, 2009 at 8:43 PM, Miguel Miranda wrote: > Well, i just didnt explain in detail, what i have is just the 16897 > directory where i was storing the database, i tried just copying the files > but it didnt work, > should it be posible to import this database is any way? Nope, you need t

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Madison Kelly
Miguel Miranda wrote: Well, i just didnt explain in detail, what i have is just the 16897 directory where i was storing the database, i tried just copying the files but it didnt work, should it be posible to import this database is any way? the Os is Freebsd 6.2 and PG version is 8.1.3 thank y

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Miguel Miranda
Well, i just didnt explain in detail, what i have is just the 16897 directory where i was storing the database, i tried just copying the files but it didnt work, should it be posible to import this database is any way? the Os is Freebsd 6.2 and PG version is 8.1.3 thank you. On Fri, Jun 19, 2009

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Madison Kelly
Miguel Miranda wrote: Hi, the worst have ocurred, my server died (cpu), so i reinstalled another server with the same postgres version. I have the old data directory from the old server, how can i restore my databases from this directory to the new one? I dont have a backup (pg_dump,etc), just t

Re: [GENERAL] Disaster recovery (server died)

2009-06-19 Thread Alan Hodgson
On Friday 19 June 2009, Miguel Miranda wrote: > Hi, the worst have ocurred, my server died (cpu), so i reinstalled > another server with the same postgres version. > I have the old data directory from the old server, how can i restore my > databases from this directory to the new one? > I dont hav

[GENERAL] Disaster recovery (server died)

2009-06-19 Thread Miguel Miranda
Hi, the worst have ocurred, my server died (cpu), so i reinstalled another server with the same postgres version. I have the old data directory from the old server, how can i restore my databases from this directory to the new one? I dont have a backup (pg_dump,etc), just the main previus live data

Re: [GENERAL] disaster recovery

2003-12-01 Thread Doug McNaught
"Rick Gigger" <[EMAIL PROTECTED]> writes: >> This is only a problem for ext2. Ext3, Reiser, XFS, JFS are all fine, >> though you get better performance from them by mounting them >> 'writeback'. > > What does 'writeback' do exactly? AFAIK 'writeback' only applies to ext3. The 'data=writeback' s

Re: [GENERAL] disaster recovery

2003-12-01 Thread Rick Gigger
> This is only a problem for ext2. Ext3, Reiser, XFS, JFS are all fine, > though you get better performance from them by mounting them > 'writeback'. What does 'writeback' do exactly? ---(end of broadcast)--- TIP 6: Have you searched our list archi

Re: [GENERAL] disaster recovery

2003-11-28 Thread Marco Colombo
On Fri, 28 Nov 2003, Craig O'Shannessy wrote: > > > > From my point of view, it's just support for my demands to have each > > mission-critical server supported by a UPS, if not redundant power > > supplies and two UPSes. > > > > Never had a kernel panic? I've had a few. Probably flakey ha

Re: [GENERAL] disaster recovery

2003-11-28 Thread Marco Colombo
On Fri, 28 Nov 2003, Alex Satrapa wrote: > Doug McNaught wrote: > > I took it as a garbled understanding of the "Linux does async metadata > > updates" criticism. Which is true for ext2, but was never the > > show-stopper some BSD-ers wanted it to be. :) > > I have on several occasions demonstr

Re: [GENERAL] disaster recovery

2003-11-28 Thread Marco Colombo
On Thu, 27 Nov 2003, Doug McNaught wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > > Doug McNaught <[EMAIL PROTECTED]> writes: > >> Alex Satrapa <[EMAIL PROTECTED]> writes: > >>> 1) Under Linux, if you have the file system containing the WAL mounted > >>> with asynchronous writes, "all bets are

Re: [GENERAL] disaster recovery

2003-11-28 Thread Craig O'Shannessy
On Fri, 28 Nov 2003, Marco Colombo wrote: > On Fri, 28 Nov 2003, Craig O'Shannessy wrote: > > > > > > > From my point of view, it's just support for my demands to have each > > > mission-critical server supported by a UPS, if not redundant power > > > supplies and two UPSes. > > > > > > > N

Re: [GENERAL] disaster recovery

2003-11-26 Thread Tom Lane
Doug McNaught <[EMAIL PROTECTED]> writes: > Alex Satrapa <[EMAIL PROTECTED]> writes: >> 1) Under Linux, if you have the file system containing the WAL mounted >> with asynchronous writes, "all bets are off". > ... > Even with ext2, WAL files are preallocated and PG calls fsync() after > writing, so

Re: [GENERAL] disaster recovery

2003-11-26 Thread Bruce Momjian
Alex Satrapa wrote: > Some caveats though: > 1) Under Linux, if you have the file system containing the WAL mounted > with asynchronous writes, "all bets are off". The *BSD crowd (that I > know of) take great pleasure in constantly reminding me that if the > power fails, my file system will be i

Re: [GENERAL] disaster recovery

2003-11-26 Thread Doug McNaught
Alex Satrapa <[EMAIL PROTECTED]> writes: > 1) Under Linux, if you have the file system containing the WAL mounted > with asynchronous writes, "all bets are off". The *BSD crowd (that I > know of) take great pleasure in constantly reminding me that if the > power fails, my file system will be in an

Re: [GENERAL] disaster recovery

2003-11-26 Thread Alex Satrapa
Jason Tesser wrote: We are evaluating Postgres and would like some input about disaster recovery. I'm going to try to communicate what I understand, and other list members can correct me at their selected level of vehemence :) Please send corrections to the list - I may take days to post follow-up

[GENERAL] disaster recovery

2003-11-26 Thread Jason Tesser
We are evaluating Postgres and would like some input about disaster recovery. I know in MsSQL they have a feature called transactional logs that would enable a database to be put back together based off those logs. Does Postgres do anything like this? I saw in the documentation transactional l