When restoring from a pg_dumpall file, is it best to delete the contents
of the data folder, run intitdb to recreate it, and then do the command
"psql -U postgres -f backupfile postgres"?
When I do the restore over top of what is in the data folder already,
there are many errors reported.
Thanks
"Buorn, Yoway" <[EMAIL PROTECTED]> writes:
> No, I'm not trying to back-port a dump. I simply followed the
> instructions in the section 2.3.4 of the gforge manual which tells me to
> go into the db/ folder and apply the schema changes in order for all sql
> files dated after the existing installa
On Tue, Aug 16, 2005 at 08:55:30AM -0700, Buorn, Yoway wrote:
> No, I'm not trying to back-port a dump. I simply followed the
> instructions in the section 2.3.4 of the gforge manual which tells me to
> go into the db/ folder and apply the schema changes in order for all sql
> files dated after th
orn, Yoway
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Restore from pg_dumpall
"Buorn, Yoway" <[EMAIL PROTECTED]> writes:
> I'm upgrading Gforge and the first sql file I tried to load gave me
> the = following error:
> DROP FUNCTION projtask_insert_depend ()
On Mon, 8 Aug 2005, Buorn, Yoway wrote:
Unfortunately, I don't have the dump and restore in my buffer, but I ran
"pg_dumpall > backup.dump" and then I tried to upgrade Gforge and I got
errors, so I freaked out and decided to restore before trying again. I
then ran "pg_restore -c backup.dump" an
>From: Jeff Frost [mailto:[EMAIL PROTECTED]
>What are you upgrading from/to? Can you share your dump and restore
command line as well?
I am upgrading from Gforge 3.0b1 to Gforge 4.5.0.1.
Unfortunately, I don't have the dump and restore in my buffer, but I ran
"pg_dumpall > backup.dump" and then
"Buorn, Yoway" <[EMAIL PROTECTED]> writes:
> I'm upgrading Gforge and the first sql file I tried to load gave me the =
> following error:
> DROP FUNCTION projtask_insert_depend () CASCADE ;
> ERROR: parser: parse error at or near "CASCADE"
> Can anyone point out to me what is wrong with this sql
Yoway,
What are you upgrading from/to? Can you share your dump and restore command
line as well?
On Fri, 5 Aug 2005, Buorn, Yoway wrote:
I'm upgrading Gforge and the first sql file I tried to load gave me the
following error:
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consultin
Title: Restore from pg_dumpall
I'm upgrading Gforge and the first sql file I tried to load gave me the following error:
--
-- Function to enforce consistency in task start/end dates
--
DROP FUNCTION projtask_insert_depend () CASCADE ;
ERROR: parser: parse error at or near "CASCA
