Re: [GENERAL] Restore database from files (not dump files)?

2006-12-12 Thread Tom Lane
wheel [EMAIL PROTECTED] writes: I guess the reason is that the pg system database etc are lodged in the hive under \base\, and the system db contains the metadata about the db to be restored? No, the reason why selective restore doesn't work is that all tables in a database cluster depend

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-12 Thread Bruce Momjian
Tom Lane wrote: wheel [EMAIL PROTECTED] writes: I guess the reason is that the pg system database etc are lodged in the hive under \base\, and the system db contains the metadata about the db to be restored? No, the reason why selective restore doesn't work is that all tables in a

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-11 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Uh, do you have the entier /data directory tree? If so, just restore the directory start it up a binary. Yes I have the entire dir/file set. But what does If so, just restore the directory start it up a binary mean? Restore

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-11 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... In article [EMAIL PROTECTED], wheel [EMAIL PROTECTED] wrote: % I copied all of the database 'parts' to the new 'base' directory. I am % not sure how carefully anyone has read what I wrote. But it's so simple % what I'm asking

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-08 Thread Patrick TJ McPhee
In article [EMAIL PROTECTED], wheel [EMAIL PROTECTED] wrote: % I copied all of the database 'parts' to the new 'base' directory. I am % not sure how carefully anyone has read what I wrote. But it's so simple % what I'm asking about, or so it would seem to me. As several people have pointed

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-07 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... On Wed, Dec 06, 2006 at 12:16:35PM -0800, wheel wrote: re Bruce Momjian Wow, what an unfriendly dude! Well, he's one of the very guys who make all this (PostgreSQL, that is) happen for us. Karsten Yes I know he's a mainstay

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-07 Thread Scott Marlowe
On Thu, 2006-12-07 at 02:41, wheel wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... On Wed, Dec 06, 2006 at 12:16:35PM -0800, wheel wrote: re Bruce Momjian Wow, what an unfriendly dude! Well, he's one of the very guys who make all this (PostgreSQL, that is) happen

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-07 Thread Scott Ribe
Uh, do you have the entier /data directory tree? If so, just restore the directory start it up a binary. Yes I have the entire dir/file set. But what does If so, just restore the directory start it up a binary mean? Restore the dir, you mean copy it to it's location under \base? What

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-06 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... [ The author's email address is clearly bogus, so I can't privately send him email.] You seems to be trying to get help by supplying the least amount of information possible, and not even fully typing out words. Such approaches

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-06 Thread Scott Marlowe
On Wed, 2006-12-06 at 14:16, wheel wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... [ The author's email address is clearly bogus, so I can't privately send him email.] You seems to be trying to get help by supplying the least amount of information possible, and not

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-06 Thread Karsten Hilbert
On Wed, Dec 06, 2006 at 12:16:35PM -0800, wheel wrote: re Bruce Momjian Wow, what an unfriendly dude! Well, he's one of the very guys who make all this (PostgreSQL, that is) happen for us. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-06 Thread Richard Broersma Jr
I don't list my email in newsgroups because they're primary resources for spammers. A lot of users will create a Junk email address specifically for this and other lists. Please realize that any user who's emails get bounced because of false email addresses, exceeded disks quotas, or

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-05 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... I have copied the folders back to the base dir (like C:\PostgreSQL \data \base\16404) if that's step one but what after that? Just start Postgres. If the data dir is ok, it should run fine. It's unclear from your description

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-05 Thread Bruce Momjian
[ The author's email address is clearly bogus, so I can't privately send him email.] You seems to be trying to get help by supplying the least amount of information possible, and not even fully typing out words. Such approaches usually fail. I suggest we ignore further emails from this person

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-04 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... wheel wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... wheel wrote: Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-04 Thread John D. Burger
I have copied the folders back to the base dir (like C:\PostgreSQL \data \base\16404) if that's step one but what after that? Just start Postgres. If the data dir is ok, it should run fine. It's unclear from your description whether the raw DB files were moved from another installation -

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-03 Thread wheel
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... wheel wrote: Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, there are many files called 1247, 1248, etc (no

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-03 Thread brian
wheel wrote: In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... wheel wrote: Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, there are many files called 1247, 1248, etc (no

[GENERAL] Restore database from files (not dump files)?

2006-12-01 Thread wheel
Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, there are many files called 1247, 1248, etc (no extension). I think these are the files that make up the database? For this db I

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-01 Thread Bruce Momjian
wheel wrote: Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, there are many files called 1247, 1248, etc (no extension). I think these are the files that make up the database?