hi,
I'm trying to make some hardware upgrades (increasing disk capacity)
to the machine where the database server is running. So, I've backed
up all the existing databases using the following command:
pg_dump -f -Fc -v
I want to restore these databases on a different machine. I've got the
post
Thanks, it worked.
On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote:
> >
> > Is there any way of copying/dumping/restoring the user and group
> > information and permissions from
hi,
I'm trying to restore some databases from the plain text format dumps.
To restore I'm using:
psql -e -f nmayande.sql template1
I captured a small part while restoring the database which has an error,
CREATE OPERATOR >= (
PROCEDURE = daterange_greater_than_equals,
LEFTARG = dateran
hi,
I'm trying to backup a server and restore it on a different machine
with newer versions of postgresql and postgis. Dumps have been created
for the following versions from the old database server:
Postgresql 7.4.6
Postgis 0.8.2
Now since both the packages have released newer versions i
ed "WKB_recv" which existed in the older version
(0.8.2)
There are many such cases where the postgis_restore.pl script fails in
removing the postgis stuff. I'm currently working on getting this
fixed.
Cheers,
Pritesh
On Wed, Feb 16, 2005 at 02:09:11AM -0700, Pritesh Shah wrote:
