Re: Recreate database but old tables still present

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Recreate database but old tables still present
Дата
Msg-id 4D667F81.5000405@lelarge.info
обсуждение исходный текст
Ответ на Recreate database but old tables still present  (gvim <gvimrc@gmail.com>)
Список pgsql-general
Le 24/02/2011 16:49, gvim a écrit :
> PostgreSQL 9.0.3/Mac OS X 10.6.6
>
> I need to recreate a database at regular intervals and what normally
> works is:
>
> user$: dropdb -U myuser -h localhost mydb;
>
> user $: psql -U myuser -h localhost mydb;
> psql: FATAL: database "mydb" does not exist
>
> user$: createdb -U myuser -h localhost mydb;
>
> Now, for some reason, when I recreate the datbase the old tables are
> still present. I've tried the same procedure using a psql login but the
> result is the same.
>

You probably created your tables in the template1 database. Check this
database if they appear here too.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: Recreate database but old tables still present
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)