"Tim Penhey" <[EMAIL PROTECTED]> writes:
> This has been a bit of a point of confusion for me.
>
> When do you use pg_restore vs. psql -f dumped.sql?
If you used the 'custom' or 'tar' formats of pg_dump, you need to use
pg_restore. If you dumped as straight SQL (the default), just feed
the dump
Scot L. Harris wrote:
>
> I just recently upgraded from 7.2.4 to 7.4.2 postgresql. What I did was
> a pg_dumpall to save my databases. Then after the upgrade I did a
> pg_restore using the saved dump file. Worked perfectly for me.
>
> After I installed the new version of postgresql I did a ini
Carter Harrison <[EMAIL PROTECTED]> writes:
> Can somebody please give me some detailed
> directions on restoring the file system correctly. I think the only
> thing that is different about this new install of postgresql is that it
> is owned by a different user than before. Thanks.
Did you m
On Sat, 2004-06-19 at 16:34, Carter Harrison wrote:
> I'm running the latest version of PostgreSQL. I backed up one of my
> databases following the instructions in the postgresql documentation.
> This means that I did shut down postmaster and I tarred the data
> directory just like it says to.
I'm running the latest version of PostgreSQL. I backed up one of my
databases following the instructions in the postgresql documentation.
This means that I did shut down postmaster and I tarred the data
directory just like it says to. Now, I'd like to restore the file
system. I started by j
