Re: GUI tools for Posgresql and database files

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: GUI tools for Posgresql and database files
Дата
Msg-id 200308181602.02030.josh@agliodbs.com
обсуждение исходный текст
Ответ на GUI tools for Posgresql and database files  (Raigo77@solo.delfi.ee (Raigo))
Ответы Re: GUI tools for Posgresql and database files  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
Список pgsql-novice
Raigo,

> I am using PostgreSQL 7.3.2 which I installed with default options
> with Mandrake 9.1, at the moment for learning. I am now using tool
> named PSQL for creating tables, views etc. But I read about tool named
> PGACCESS which is GUI. My question: is this installed somewhere by
> default? if yes how to run it?

Please see http://techdocs.postgresql.org/guides/GUITools

> my second question: where does PostgreSQL 7.3.2 put it's physical
> database files? In Interbase I just need to copy *.gdb files if I move
> from one machine to another. I read in Postgres there is a directory
> for each database for example database mydb is in
> /usr/local/pgsql/database/mydb which holds one database. But in my
> installation I don't have that directory. I did search with mydb name,
> but it did not find anything. where to look and which files are needed
> if I want to move databases?

If you need to move a database, you do not want to do it by copying files.
Instead, make a backup using pg_dump or pg_dumpall and restore that to the
new location.  See the documentation on pg_dump for details (or better yet,
consult your favorite PostgreSQL book).

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Raigo77@solo.delfi.ee (Raigo)
Дата:
Сообщение: GUI tools for Posgresql and database files
Следующее
От: Bryan Irvine
Дата:
Сообщение: Re: GUI tools for Posgresql and database files