Thread: GUI tools for Posgresql and database files

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?

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?

thanks for ideas.

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

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