Thread: Porting existing postgresql databases to another machine
I'm trying to port some existing postgresql databases to another machine I'd really like to replicate the databases on the second machine, but would accept a process that just copies the data over Can anyone point me to a how-to or offer some advice?
Brian, > I'm trying to port some existing postgresql databases to another > machine > > I'd really like to replicate the databases on the second machine, but > would > accept a process that just copies the data over > > Can anyone point me to a how-to or offer some advice? HTTP://techdocs.postgresql.org/ Though, quite frankly, if you're running on Unix the fastest process is to use pg_dump files. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
I found what I was looking for here: http://www.ca.postgresql.org/users-lounge/docs/7.1/admin/migration.html It took me hours to find it though -----Original Message----- From: Josh Berkus [mailto:josh@agliodbs.com] Sent: Friday, January 25, 2002 11:32 AM To: Brian Johnson; pgsql-novice@postgresql.org Subject: Re: [NOVICE] Porting existing postgresql databases to another machine Brian, > I'm trying to port some existing postgresql databases to another > machine > > I'd really like to replicate the databases on the second machine, but > would > accept a process that just copies the data over > > Can anyone point me to a how-to or offer some advice? HTTP://techdocs.postgresql.org/ Though, quite frankly, if you're running on Unix the fastest process is to use pg_dump files. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco