Re: GUI tools for Posgresql and database files
От | Bryan Irvine |
---|---|
Тема | Re: GUI tools for Posgresql and database files |
Дата | |
Msg-id | 1061248438.4137.20.camel@elvis обсуждение исходный текст |
Ответ на | Re: GUI tools for Posgresql and database files (Josh Berkus <josh@agliodbs.com>) |
Список | pgsql-novice |
no it's not installed somehwere by default. It's comes with the postgresql-tcl package. try this from the cli (as root) urpmi postgresql-tcl Then you will have pgaccess. --Bryan On Mon, 2003-08-18 at 16:02, Josh Berkus wrote: > 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).
В списке pgsql-novice по дате отправления: