Postgres Pro
Downloads
Home   >   mailing lists

Thread: Pgbadger

Pgbadger

From
Yambu
Date:
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

Re: Pgbadger

From
Julien Rouhaud
Date:
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. 

Re: Pgbadger

From
Yambu
Date:
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. 

Comparing 2 data base or 2 tables

From
koff10
Date:

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

Re: Comparing 2 data base or 2 tables

From
Holger Jakobs
Date:
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 -

Re: Comparing 2 data base or 2 tables

From
"Dai, Tino"
Date:

​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
 
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 -

Re: Comparing 2 data base or 2 tables

From
koff10
Date:
Thanks lot,
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 -

Re: Comparing 2 data base or 2 tables

From
Ron
Date:
Meld is an excellnet file compare program.

On 6/28/21 6:41 AM, koff10 wrote:
Thanks lot,
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 -


--
Angular momentum makes the world go 'round.

Re: Comparing 2 data base or 2 tables

From
Mukesh Rajpurohit
Date:
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

Re: Comparing 2 data base or 2 tables

From
koff10
Date:
Thanks all  for your feed back
@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.

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

Re: Comparing 2 data base or 2 tables

From
Vineet Naik
Date:
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