Where is the PostgreSQL DB located?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Where is the PostgreSQL DB located?

Postby Goomashroom » Tue Feb 26, 2008 3:18 am

So I used to use Access DBs and basically I want to keep my PostgreSQL DBs on an external hard drive... where are they located/how do I move them? Thanks
Goomashroom
 
Posts: 56
Joined: Sat Feb 02, 2008 12:08 am

Re: Where is the PostgreSQL DB located?

Postby APerfect10 » Tue Feb 26, 2008 3:28 am

The PostgreSQL database is much more powerful than Access. Because of this your database is not stored in a single file but an array of files located in your Program Files/PostgreSQL/8.3/data/base directory. You should [bpny]NOT[/bpny] touch these files.

If you would like to move your database to an external hard drive then you should read this thread, [url=http://www.pokertracker3.com/forums/viewtopic.php?f=17&t=526&start=0pny]Create new db in a different drive[/urlpny]. Dave provides a good step by step tutorial on how to do this.

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron