pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedComparing two databases for differences
8+ messages / 7 participants
[nested] [flat]
* Comparing two databases for differences
@ 2014-12-10 14:08 Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
0 siblings, 4 replies; 8+ messages in thread
From: Ferrell, Denise CTR NSWCDD, Z11 @ 2014-12-10 14:08 UTC (permalink / raw)
To: pgsql-admin
Running PostgreSQL 9.3.5 on Linux.
Does anyone know of an easy way to compare 2 database instances? Especially the stored procedures and tables from the two databases.
Thank you in advance.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 14:13 Denish Patel <denish@omniti.com>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
3 siblings, 1 reply; 8+ messages in thread
From: Denish Patel @ 2014-12-10 14:13 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
The easiest way to compare schema by using
https://github.com/omniti-labs/pg_extractor to dump objects into separate
git repo for each database and look for difference in both repos.
On Wed, Dec 10, 2014 at 9:08 AM, Ferrell, Denise CTR NSWCDD, Z11 <
denise.ferrell.ctr@navy.mil> wrote:
> Running PostgreSQL 9.3.5 on Linux.
>
> Does anyone know of an easy way to compare 2 database instances?
> Especially the stored procedures and tables from the two databases.
>
> Thank you in advance.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Denish Patel,
OmniTI Computer Consulting Inc.
Database Architect,
http://omniti.com/does/data-management
http://www.pateldenish.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 14:14 Stephen Frost <sfrost@snowman.net>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
3 siblings, 1 reply; 8+ messages in thread
From: Stephen Frost @ 2014-12-10 14:14 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
Denise,
* Ferrell, Denise CTR NSWCDD, Z11 (denise.ferrell.ctr@navy.mil) wrote:
> Does anyone know of an easy way to compare 2 database instances? Especially the stored procedures and tables from the two databases.
The Nagios module check_postgres.pl has the ability to compare database
instances.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 14:15 Denish Patel <denish@omniti.com>
parent: Denish Patel <denish@omniti.com>
0 siblings, 0 replies; 8+ messages in thread
From: Denish Patel @ 2014-12-10 14:15 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
you don't have to use Git repo. Just dump objects using pg_extractors in
two folders and run "diff" between them.
On Wed, Dec 10, 2014 at 9:13 AM, Denish Patel <denish@omniti.com> wrote:
> The easiest way to compare schema by using
> https://github.com/omniti-labs/pg_extractor to dump objects into separate
> git repo for each database and look for difference in both repos.
>
> On Wed, Dec 10, 2014 at 9:08 AM, Ferrell, Denise CTR NSWCDD, Z11 <
> denise.ferrell.ctr@navy.mil> wrote:
>
>> Running PostgreSQL 9.3.5 on Linux.
>>
>> Does anyone know of an easy way to compare 2 database instances?
>> Especially the stored procedures and tables from the two databases.
>>
>> Thank you in advance.
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>
>
>
> --
> Denish Patel,
> OmniTI Computer Consulting Inc.
> Database Architect,
> http://omniti.com/does/data-management
> http://www.pateldenish.com
>
--
Denish Patel,
OmniTI Computer Consulting Inc.
Database Architect,
http://omniti.com/does/data-management
http://www.pateldenish.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 19:53 jaime soler <jaime.soler@gmail.com>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
3 siblings, 0 replies; 8+ messages in thread
From: jaime soler @ 2014-12-10 19:53 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
El mié, 10-12-2014 a las 14:08 +0000, Ferrell, Denise CTR NSWCDD, Z11
escribió:
> Running PostgreSQL 9.3.5 on Linux.
>
> Does anyone know of an easy way to compare 2 database instances? Especially the stored procedures and tables from the two databases.
I have used several times aquadatastudio:
http://www.aquafold.com/aquadatastudio/schema_sql_compare.html
>
> Thank you in advance.
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 19:55 Greg Sabino Mullane <greg@turnstep.com>
parent: Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 8+ messages in thread
From: Greg Sabino Mullane @ 2014-12-10 19:55 UTC (permalink / raw)
To: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
>> Does anyone know of an easy way to compare 2 database instances?
> The Nagios module check_postgres.pl has the ability to compare database instances.
To expand on how easy this is:
wget -q http://bucardo.org/downloads/check_postgres.pl
perl check_postgres.pl --action=same_schema --db=mydb1 --db=mydb2
More details here:
http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201412101455
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAlSIpRkACgkQvJuQZxSWSsgJXwCeL7pqzLsez4FkUpq0ZopW4HyD
o40AnjY3wa+/LpbQRIKkVgsnMbdYdPuD
=aJk3
-----END PGP SIGNATURE-----
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 21:11 Strahinja Kustudić <strahinjak@nordeus.com>
parent: Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 0 replies; 8+ messages in thread
From: Strahinja Kustudić @ 2014-12-10 21:11 UTC (permalink / raw)
To: Greg Sabino Mullane <greg@turnstep.com>; +Cc: pgsql-admin
I used this before and it worked great http://apgdiff.com/, but it cannot
compare data, only schemas and stored procedures.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing two databases for differences
@ 2014-12-10 23:37 Devrim Gündüz <devrim@gunduz.org>
parent: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
3 siblings, 0 replies; 8+ messages in thread
From: Devrim Gündüz @ 2014-12-10 23:37 UTC (permalink / raw)
To: Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin
Hi,
On Wed, 2014-12-10 at 14:08 +0000, Ferrell, Denise CTR NSWCDD, Z11
wrote:
> Does anyone know of an easy way to compare 2 database instances?
> Especially the stored procedures and tables from the two databases.
You can use pg_comparator -- also available in YUM repository.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2014-12-10 23:37 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-10 14:08 Comparing two databases for differences Ferrell, Denise CTR NSWCDD, Z11 <denise.ferrell.ctr@navy.mil>
2014-12-10 14:13 ` Denish Patel <denish@omniti.com>
2014-12-10 14:15 ` Denish Patel <denish@omniti.com>
2014-12-10 14:14 ` Stephen Frost <sfrost@snowman.net>
2014-12-10 19:55 ` Greg Sabino Mullane <greg@turnstep.com>
2014-12-10 21:11 ` Strahinja Kustudić <strahinjak@nordeus.com>
2014-12-10 19:53 ` jaime soler <jaime.soler@gmail.com>
2014-12-10 23:37 ` Devrim Gündüz <devrim@gunduz.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox