Bob Lu= nney

--- On Wed, 1/19/11, French, Martin <frenchm@cromwell.= co.uk> wrote:

From: French, Mart= in <frenchm@cromwell.co.uk>
Subject: Re: [ADMIN] Postgres Backup U= tility
To: "Bradley Holbrook" <operations_bradley@servillian.ca>Cc: pgsql-admin@postgresql.org
Date: Wednesday, January 19, 2011, 2:12= AM

=0A=0A=0A =0A =0A=0A=0A=0A=0A =0A=0A
=0A=0A
Ok, you say that you cannot drop=0Aand recreate, so you= need to do this via alter statements only? That=E2=80=99s=0Aobviously goin= g to complicate matters, as a straight dump, drop, recreate,=0Arestore woul= d be the fastest and by far simplest method.
=0A=0A

= =0A=0A
So= , Ideally, you=E2=80=99ll need=0Ato do a table def comparison over the two = databases, and generate the necessary=0Asql to amend the tables in test acc= ordingly?
=0A=0A

=0A=0A
Querying the pg_catalog/information_sc= hema=0Aover the two db=E2=80=99s should give you the table ddl from which y= ou can diff,=0Aand then generate the alter statements from the results.
=0A=0A

=0A=0A
Cheers
=0A=0A

=0A=0A
Martin =0A=0A
=
=0A=0A
=0A=0A
=0A=0A
From: Bradley Holbrook=0A[mailto:operations_bradley@servilli= an.ca]
=0ASent: 18 January 2011 16:57
=0ATo: French, M= artin
=0ACc: pgsql-admin@postgresql.org
=0ASubject: RE:= [ADMIN] Postgres Backup Utility
=0A=0A
=0A=0A
=0A=0A<= p class=3D"yiv1343573220MsoNormal">
=0A=0A
Well,=0AI can=E2=80=99t just go dropping and recreating tables=E2=80=A6 it= needs to create=0Athe correct alter statements if existing tables and or f= unctions already exist.
=0A=0A

=0A=0A
Secondly,=0Awhen I=E2=80=99m finished = changing the structure, I need to be able to select the=0Alist of tables th= at will have content updates.
=0A=0A
&nbs= p;
=0A=0A
Using=0Aa script might be more w= ork maintaining then it=E2=80=99s worth. I have a backup=0Autility that can= do the job, but 3 tedious steps per schema, that only work=0Aabout 10% of = the time (and no batching options so that I can create a list of=0Aactions = and run the list).
=0A=0A
=0A=0A

=0A=0A
=0A=0A
=0A=0A
From: French, Martin=0A[mail= to:frenchm@cromwell.co.uk]
=0ASent: January-18-11 5:47 AM
=0A= To: Bradley Holbrook; pgsql-admin@postgresql.org
=0ASubject: RE: [ADMIN] Postgres Backup Utility
=0A=0A
=0A=0A
= =0A=0A

=0A=0A
I=E2=80=99m assuming that this=0Aneeds to be tightly controlled and as= such a replication tool is out of the=0Aquestion?
=0A=0A
<= /p> =0A=0A
In that case; The first thing to=0Apop into my head here would be to use = either use shell scripting, or to use the=0Apg API and write a c program to= handle it.
=0A=0A

=0A=0A
I remember doing something very=0Asim= ilar with Oracle a few years back.
=0A=0A

=0A=0A
Cheers<= /p> =0A=0A

=0A=0A
Martin
=0A=0A

=0A=0A

=0A= =0A
=0A=0A
=0A=0A
From:= p= gsql-admin-owner@postgresql.org=0A[mailto:pgsql-admin-owner@postgresql.org]= On Behalf Of Bradley Holbrook
=0ASent: 18 January 2011 00= :08
=0ATo: pgsql-admin@postgresql.org
=0ASubject: [ADMI= N] Postgres Backup Utility
=0A=0A
=0A=0A
=0A=0A

=0A=0A
Hello= !
=0A=0A

=0A=0A
First=0Aday on the new mailing list as I have need of some e= xpert=E2=80=99s advice.
=0A=0A

=0A=0A
I=0Aneed to be able to quickly apply t= he structure updates from a development=0Adatabase to a testing database, a= nd do selective data updates (like on lookup=0Atables, but not content tabl= es).
=0A=0A

=0A=0A
Any=0Ahelp would be appreciated!
=0A=0A

=0A=0A
Brad=
=0A=0A

=0A_______________= ____________________________________
=0A
=0AThis email is intended f= or the named recipient. The information contained
=0Ain it is confident= ial. You should not copy it for any purposes, nor
=0Adisclose its conte= nts to any other party. If you received this email
=0Ain error, please = notify the sender immediately via email, and delete
=0Ait from your com= puter.
=0A
=0AAny views or opinions presented are solely those of th= e author and do not
=0Anecessarily represent those of the company.
= =0A
=0APCI Compliancy: Please note, we do not send or wish to receive ba= nking,
=0Acredit or debit card information by email or any other form o= f
=0Acommunication.
=0A
=0ACromwell Tools Limited, PO Box 14, 65= Chartwell Drive
=0AWigston, Leicester LE18 1AT. Tel 0116 2888000
= =0ARegistered in England and Wales, Reg No 00986161
=0AVAT GB 115 5713 = 87 900
=0A__________________________________________________ =0A=0A
=0A=0A =0A=0A
____________________________________________= _______ =0A
=0A
This email is intended for the named recipient. The= information contained =0A
in it is confidential. You should not copy i= t for any purposes, nor =0A
disclose its contents to any other party. I= f you received this email =0A
in error, please notify the sender immedia= tely via email, and delete=0A
it from your computer. =0A
=0A
Any= views or opinions presented are solely those of the author and do not =0A<= br>necessarily represent those of the company. =0A
=0A
PCI Complian= cy: Please note, we do not send or wish to receive banking,=0A
credit or= debit card information by email or any other form of =0A
commu= nication. =0A
= =0ACromwell Tools Limited, PO Box 14, 65 Chartwell Drive=0A
Wigston, Leice= ster LE18 1AT. Tel 0116 2888000=0A
Registered in England and Wales, Reg = No 00986161=0A
VAT GB 115 5713 87 900=0A
____________________________= ______________________=0A=0A