Re: pg_dump - how to force to show timestamps in client log

2020-11-21 Thread Peter J. Holzer
On 2020-11-20 19:01:47 +0100, Durumdara wrote: > We need to log the pg_dump's state. > What objects are in copy, and what are the starting and ending times. > > But when I try to redirect the output, the result doesn't have timestamps. > > PG 11, on Windows. > > As I see the -v option isn't enou

Re: pg_dump - how to force to show timestamps in client log

2020-11-21 Thread Ron
TBH, it's also been a while since I needed to monitor pg_dump, since we now use pgbackrest (which just so happens to have a progress meter...). On 11/20/20 4:32 PM, Mark Johnson wrote: This all sounds like a previous discussion on pg hackers about a progress meter for pg_dump.  Search the archi

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Mark Johnson
This all sounds like a previous discussion on pg hackers about a progress meter for pg_dump. Search the archives for that discussion. Also, search the web for something like "pg_dump progress meter" and you'll get a few suggestions like pipe to pv, although that does not appear to work with all o

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Ron
On 11/20/20 3:39 PM, Adrian Klaver wrote: On 11/20/20 1:00 PM, Ron wrote: On 11/20/20 2:56 PM, Adrian Klaver wrote: On 11/20/20 10:01 AM, Durumdara wrote: Hello! We need to log the pg_dump's state. What objects are in copy, and what are the starting and ending times. But when I try to redire

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Adrian Klaver
On 11/20/20 1:00 PM, Ron wrote: On 11/20/20 2:56 PM, Adrian Klaver wrote: On 11/20/20 10:01 AM, Durumdara wrote: Hello! We need to log the pg_dump's state. What objects are in copy, and what are the starting and ending times. But when I try to redirect the output, the result doesn't have tim

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Ron
On 11/20/20 2:56 PM, Adrian Klaver wrote: On 11/20/20 10:01 AM, Durumdara wrote: Hello! We need to log the pg_dump's state. What objects are in copy, and what are the starting and ending times. But when I try to redirect the output, the result doesn't have timestamps. PG 11, on Windows. As I

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Adrian Klaver
On 11/20/20 10:01 AM, Durumdara wrote: Hello! We need to log the pg_dump's state. What objects are in copy, and what are the starting and ending times. But when I try to redirect the output, the result doesn't have timestamps. PG 11, on Windows. As I see the -v option isn't enough to see the

Re: pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Joshua Drake
Howdy, pg_dump is just issuing SQL commands, you could turn on timestamps in your postgresql log. JD On Fri, Nov 20, 2020 at 10:02 AM Durumdara wrote: > Hello! > > We need to log the pg_dump's state. > What objects are in copy, and what are the starting and ending times. > > But when I try to

pg_dump - how to force to show timestamps in client log

2020-11-20 Thread Durumdara
Hello! We need to log the pg_dump's state. What objects are in copy, and what are the starting and ending times. But when I try to redirect the output, the result doesn't have timestamps. PG 11, on Windows. As I see the -v option isn't enough to see the starting times. For example: 2020-11-19