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