When grilled further on (Tue, 05 Oct 2004 17:26:16 -0700),
Dan Hrabarchuk <[EMAIL PROTECTED]> confessed:
> I need to move a large database to new machine. I'd also like to upgrade
> my postgres server from 7.3 to 7.4 (at least).
>
I think Slony (http://www.slony.org) will do exactly what you des
Lamar Owen wrote:
On Thursday 30 September 2004 00:07, John McBride wrote:
As user postgres I try and run the tests:
$ pwd
/usr/lib/pgsql/test/regress
$ time ./pg_regress.sh --schedule=parallel_schedule
[snip]
===
Now, if you'll look very carefully the create_funtion_1 failure is due t
I need to move a large database to new machine. I'd also like to upgrade
my postgres server from 7.3 to 7.4 (at least).
My plan is to set up a query log on my current postgres server. Then I
will make a copy of the database using pg_dump. When the dump is done I
will to shut down the original serv
Whoever wrote the Arkeia pages was very confused. I've communicated with
them previously, but no one was home.
My understanding is that those are MySQL flag settings, not PostgreSQL.
Whatever, they certainly don't work with PostgreSQL.
"Tracking changes" while you do a dump is exactly what PITR
banghe wrote:
One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc
from table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
id : in
One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc from
table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
id : integer
name : s
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
id : integer
name : string
desc : string
Table B
id : integer
name : string
date : date
summary : string
In this example, I would like to copy all the data f
Hi everyone,
Have any of you successfully compiled pgadmin3 on SuSE 9.1.
I've tried googleing for answers but I've yet to find someone that can tell my
why my build keeps falling over at the final link stage.
Right now it seems that the wx libraries are not found for some reason, as I
keep get
Hello
I am thinking about using the Redhat Cluster software. Could you tell
me a about the hardware requirements and what type of configuration you
are running.
Thanks
Gaetano Mendola wrote:
John Allgood wrote:
Hello All
I am looking for information on postgres failover solutions. I
have r