Обсуждение: Pgbadger
Hello
Is it possible to make pgbadger automatically pick latest postgres logs files and show it in browser, without me running the pgbadger command manually?
regards
Le lun. 28 juin 2021 à 09:59, Yambu <hyambu@gmail.com> a écrit :
Is it possible to make pgbadger automatically pick latest postgres logs files and show it in browser, without me running the pgbadger command manually?
you need to setup a cron task for that, or any other scheduler. see https://github.com/darold/pgbadger#INCREMENTAL-REPORTS for some examples.
Ok, thank you all
On Mon, Jun 28, 2021 at 4:11 AM Julien Rouhaud <rjuju123@gmail.com> wrote:
Le lun. 28 juin 2021 à 09:59, Yambu <hyambu@gmail.com> a écrit :Is it possible to make pgbadger automatically pick latest postgres logs files and show it in browser, without me running the pgbadger command manually?you need to setup a cron task for that, or any other scheduler. see https://github.com/darold/pgbadger#INCREMENTAL-REPORTS for some examples.
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
Dump them using pg_dump and compare the files.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
If you are on a mac, you can use a tool called diff
-T
From: Holger Jakobs <holger@jakobs.com>
Sent: Monday, June 28, 2021 7:26 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
Sent: Monday, June 28, 2021 7:26 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
Dump them using pg_dump and compare the files.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
Thanks lot,
I did not think about it
koff
I did not think about it
koff
Le 28/06/2021 à 13:26, Holger Jakobs a écrit :
Dump them using pg_dump and compare the files.Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
Meld is an excellnet file compare program.
On 6/28/21 6:41 AM, koff10 wrote:
Thanks lot,
I did not think about it
koffLe 28/06/2021 à 13:26, Holger Jakobs a écrit :Dump them using pg_dump and compare the files.Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
You may use EXCEPT keyword to compare two tables in two databases, plz use postgres_fdw for connectivity.
Thanks
Mukesh
On Mon, Jun 28, 2021, 4:42 PM koff10 <koff10@hotmail.com> wrote:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
Thanks all for your feed back
@Mukesh , I daily use postgres_fdw but not plz . How does it work?
@Mukesh , I daily use postgres_fdw but not plz . How does it work?
Le 28/06/2021 à 14:04, Mukesh Rajpurohit a écrit :
You may use EXCEPT keyword to compare two tables in two databases, plz use postgres_fdw for connectivity.ThanksMukeshOn Mon, Jun 28, 2021, 4:42 PM koff10 <koff10@hotmail.com> wrote:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
On Mon, Jun 28, 2021 at 4:42 PM koff10 <koff10@hotmail.com> wrote: > > > Hi All, > I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas > and extract data differences. pgAdmin 4 comes with a schema diff tool that's pretty good - https://www.pgadmin.org/docs/pgadmin4/5.4/schema_diff.html > I need a little help please. > thanks lot. > > koff Berta ~ Vineet