How to restore database without re-write database and tables owner by using postgres

Поиск
Список
Период
Сортировка
От Cidy Long
Тема How to restore database without re-write database and tables owner by using postgres
Дата
Msg-id C35FABA3-0B31-43CD-B2F2-273CADEE026C@gmail.com
обсуждение исходный текст
Ответы Re: How to restore database without re-write database and tables owner by using postgres  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: CREATE DATABASE cannot be executed within a pipeline
Следующее
От: Sandeep Thakkar
Дата:
Сообщение: Re: BUG #17934: Cannot run pgAdmin after upgrading from 15.2 to 15.3