Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    18

    Exclamation Unanswered: PostGreSQL Table files

    Hi guys, can some1 tel me where are the database and table files of postgresql instalation stored in win32. Let say i install pgsql on this PC and created database with tables, now i wonna copy this database and tables to ather PC can i just copy this files and past to ather PC?? and if yes where are they?? thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by gev
    Hi guys, can some1 tel me where are the database and table files of postgresql instalation stored in win32
    The files (there are lots of them) are stored in the directory that you specify when you run initdb

    http://www.postgresql.org/docs/8.1/s...g-cluster.html

    Let say i install pgsql on this PC and created database with tables, now i wonna copy this database and tables to ather PC can i just copy this files and past to ather PC?? and if yes where are they?? thanks.
    Backup and restore your database:

    http://www.postgresql.org/docs/8.1/static/backup.html

  3. #3
    Join Date
    Jan 2006
    Posts
    18
    Thank you shammat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •