Member Avatar for tqmd1

Dear Experts

I am using windows 7 32bit.

I have created database named "accounts" and 2 tables in it through pgAdmin III. The database is working well but I am unable to found it physical location on hard disk.

On what path should I find it?

Thanks

  • 2 Contributors
  • 1 Reply
  • 282 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

You said 32 bit but I am including both just for reference.
32 bit.
On windows7 all the database are referred by a number in the file named pg_database under C:\Program Files\PostgreSQL\<version>\data\global. Then you should search for the folder name by that number under C:\Program Files\PostgreSQL\<version>\data\base. That is the content of the database.
64 bit.
On windows7 all the database are referred by a number in the file named pg_database under C:\Program Files (x86)\PostgreSQL\<version>\data\global. Then you should search for the folder name by that number under C:\Program Files (x86)\PostgreSQL\<version>\data\base. That is the content of the database.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.