Re: migrating to 9.2 created blank dbs
| От | Keith Fiske |
|---|---|
| Тема | Re: migrating to 9.2 created blank dbs |
| Дата | |
| Msg-id | CAG1_KcCzq71a5F-ukHvQB4q-y34R1C=tsVYKQcZJgJr5orgzEA@mail.gmail.com обсуждение исходный текст |
| Ответ на | migrating to 9.2 created blank dbs (Marc Fromm <Marc.Fromm@wwu.edu>) |
| Ответы |
Re: migrating to 9.2 created blank dbs
|
| Список | pgsql-admin |
On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
I setup a server running postgresql-server-9.2.10-2.el7_1.x86_64. After restoring my databases form a system running postgresql-server-8.1.23-10.el5_10 (created with pg_dumpall), several blank databases/entries were created.
When I list the database from the command line it shows several entries like:
| | | | | =T/postgres
After importing the databases is there a cleanup command of some sort?
These blank databases/entries do not show in PhpPgAdmin, yet my backup script tries to backup a database called “|”
Thanks
Marc
Did you run the 9.2 version of pg_dumpall or the 8.1 version to create your original dump file? You should run the 9.2 version on the 8.1 database if possible.
В списке pgsql-admin по дате отправления: