Recreate database but old tables still present

Поиск
Список
Период
Сортировка
От gvim
Тема Recreate database but old tables still present
Дата
Msg-id 4D667E27.40003@gmail.com
обсуждение исходный текст
Ответы Re: Recreate database but old tables still present  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Re: Recreate database but old tables still present  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
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
apsql login but the result is the same. 

gvim



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

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