Re: backup -restore question

2020-07-13 Thread Ron
On 7/13/20 7:37 PM, Adrian Klaver wrote: On 7/13/20 2:56 PM, Ron wrote: On 7/13/20 2:32 PM, Adrian Klaver wrote: On 7/13/20 12:12 PM, Julie Nishimura wrote: Hello there, One of our PostgreSQL 9.4.1  databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the r

Re: backup -restore question

2020-07-13 Thread Adrian Klaver
On 7/13/20 2:56 PM, Ron wrote: On 7/13/20 2:32 PM, Adrian Klaver wrote: On 7/13/20 12:12 PM, Julie Nishimura wrote: Hello there, One of our PostgreSQL 9.4.1  databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the right format of restore this file when nee

Re: backup -restore question

2020-07-13 Thread Ron
On 7/13/20 2:32 PM, Adrian Klaver wrote: On 7/13/20 12:12 PM, Julie Nishimura wrote: Hello there, One of our PostgreSQL 9.4.1  databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the right format of restore this file when needed? Can I run the restore from

Re: backup -restore question

2020-07-13 Thread Adrian Klaver
On 7/13/20 12:12 PM, Julie Nishimura wrote: Hello there, One of our PostgreSQL 9.4.1  databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the right format of restore this file when needed? Can I run the restore from a compressed file or I need to unzip the

backup -restore question

2020-07-13 Thread Julie Nishimura
Hello there, One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the right format of restore this file when needed? Can I run the restore from a compressed file or I need to unzip the file first, then run pg_restore? Thanks