[postgis-users] Correct dump and restore

[strk at refractions.net]

See 'Hard Upgrade' section in postgis manual.
--strk;

On Fri, Nov 10, 2006 at 02:53:52PM +0100, Stefan Schwarzer wrote:
> Hi there,
> 
> I've seen the subject coming up already a couple of times. But it  
> didn't really help me and I can't imagine that there isn't a simple  
> strategy/method for that:
> 
> I need to make a copy of a database which resides on one computer and  
> install that copy on another.
> 
> Computer 1 (Linux) has (PostgreSQL) 8.1.0
> Computer 2 (Mac) has (PostgreSQL) 8.1.2
> 
> Don't know about the version of PostGIS.
> 
> I tried various pg_dump and pg_restore parameters. But the restore  
> never worked correctly. I tried it as well with a simple psql but  
> there too I was faced with problems...
> 
> Can anyone perhaps give me an advice how to correctly export-import a  
> database?
> 
> Thanks for any hints!
> 
> Stefan
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.