[GENERAL] postgresql8.0 and postgis1.0.0

2005-02-16 Thread Pritesh Shah
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

Re: [GENERAL] postgresql8.0 and postgis1.0.0

2005-02-16 Thread Pritesh Shah
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: hi, I'm trying to backup a server and restore

Re: [GENERAL] dumping and restoring user information.

2005-02-03 Thread Pritesh Shah
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 the old machine to the new one so

[GENERAL] errors while restoring data.

2005-02-03 Thread Pritesh Shah
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 =

[GENERAL] dumping and restoring user information.

2005-01-31 Thread Pritesh Shah
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 location_for_dump -Fc -v dbname I want to restore these databases on a different