Re: GUI tools for Posgresql and database files

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).