Postgres Pro
Downloads
Home   >   mailing lists

How to restore database without re-write database and tables owner by using postgres - Mailing list pgsql-bugs

From Cidy Long
Subject How to restore database without re-write database and tables owner by using postgres
Date
Msg-id C35FABA3-0B31-43CD-B2F2-273CADEE026C@gmail.com
Whole thread Raw
Responses Re: How to restore database without re-write database and tables owner by using postgres
List pgsql-bugs
Tree view
Hi. Here.

I’m trying to restore multiple database backup tar files to new database server on PostgreSQL-15 by run command in shell script

    /usr/pgsql-15/bin/pg_restore -v --no-owner --host=$h --port=$db_port --username=postgres --dbname=$db_name $db_tar_file

but I found, the restored database’s owner and its tables owner was replaced by connect user (super user——postgres).

I tired to find out How to keep the database and its table original owner, I don’t find any thing.

Please advise!

Cidy

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: CREATE DATABASE cannot be executed within a pipeline
Next
From: Sandeep Thakkar
Date:
Subject: Re: BUG #17934: Cannot run pgAdmin after upgrading from 15.2 to 15.3