Problem on PostgreSQL - creating database

Marius Andreiana mandreiana at rdslink.ro
Wed Aug 18 06:17:35 UTC 2004


On Wed, 2004-08-18 at 08:16 +0300, Jarkko Elfving wrote:
> Thanks a lot! It works!
> 
> But... now when I'm building up that database, does it locate in to my
> spicified location or somewhere else?
createdb --help
  -D, --location=PATH       alternative place to store the database

so yes. You'd better read the help, I won't repeat it here anymore.
You can also try 8.0 beta, which has table spaces and allows you to
split db by tables.

> Which command I can find it where it did go? 
ls

> And if I should move it to
> somewhere else (or if I do a SQL-based program exp. with Java) can I use
> that database without PostgreSQL services?
you 'move' it with pg_dump and restore with psql

> Lot's of stupid questions but I'm now so exciting of this :D
Postgresql manual is really great ;)

-- 
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro





More information about the fedora-list mailing list