coming back to postgresql after several years of oracle ...
what are the state-of-the art postgresql administrative/ddl generating/data inserting frontends on windows? it would be nice if it had integration for postgis as well. it should be standalone or alternatively a plugin for intellij idea
thinking back, all the windows programs specific for postgresql i have used were crap, especially PGAdmin. had it become better?
If you learn by example, like I do, then this is the best book to learn a complete solution. I have been trying to figure out how to put all the parts together for quite some time, but every resource gives just enough to create frustration.but NOT this book. Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac app. It includes everything you need to get started: we’ve even included popular extensions like PostGIS for geo data and plv8 for JavaScript. PostgreSQL is one of the best database engines for an average web project and many who moves to psql from mysql (for example) often ask the following questions: what is the analog of “show tables” in postgres? Or how can I get the list of databases in postgres like “show databases” in mysql? PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database; and it is also available.
Andreas Peterssonclosed as not constructive by Bo Persson, Linger, Jens Björnhager, AlphaMale, CésarDec 13 '12 at 14:40
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
9 Answers
I like Postgresql Maestro. I also use their version for MySql. I'm pretty statisfied with their product. Or you can use the free tool PgAdmin.
Francis B.Francis B.do you mean something like pgAdmin for administration?
Milen A. RadevActually there is a freeware version of EMS's SQL Manager which is quite powerful
I heartily recommended dbVis. The client runs on Mac, Windows and Linux and supports a variety of database servers, including PostgreSQL.
jwfearnjwfearnI recommend Navicat strongly. What I found particularly excellent are it's import functions - you can import almost any data format (Access, Excel, DBF, Lotus ...), define a mapping between the source and destination which can be saved and is repeatable (I even keep my mappings under version control).
I have tried SQLMaestro and found it buggy (particularly for data import); PGAdmin is limited.
For anyone looking for a web-enabled client for Postgres, I'll just put the link out here to TeamPostgreSQL, a very polished AJAX web client for pg:
EMS's SQL Manager is much easier to use and has many more features than either phpPgAdmin or PG Admin III. However, it's windows only and you have to pay for it.
HergeHergeSQLExplorer is a great Eclipse plugin or standalone interface that works with many different database systems, either with dedicated drivers or with ODBC.
LiamLiamphpPgAdmin is PostgreSQL web frontend which is quite good.
vogvogNot the answer you're looking for? Browse other questions tagged windowspostgresqlfrontendpostgis or ask your own question.
Where are the files for a PostgreSQL database stored?
Acumenus12 Answers
Snippet Tool For Mac
To see where the data directory is, use this query.
To see all the run-time parameters, use
You can create tablespaces to store database objects in other parts of the filesystem. To see tablespaces, which might not be in that data directory, use this query.
Mike Sherrill 'Cat Recall'Mike Sherrill 'Cat Recall'On Windows7 all the databases are referred by a number in the file named pg_database under C:Program Files (x86)PostgreSQL8.2dataglobal. Then you should search for the folder name by that number under C:Program Files (x86)PostgreSQL8.2database. That is the content of the database.
Open pgAdmin and go to Properties for specific database. Find OID and then open directory
There should be your DB files.
Almir SarajčićAlmir SarajčićUnder my Linux installation, it's here: /var/lib/postgresql/8.x/
You can change it with initdb -D 'c:/mydb/'
As suggested in 'PostgreSQL database default location on Linux', under Linux you can find out using the following command:
The location of specific tables/indexes can be adjusted by TABLESPACEs:
the Tin ManPostgres stores data in files in its data directory. Follow the steps below to go to a database and its files:
The database corresponding to a postgresql table file is a directory. The location of the entire data directory can be obtained by running SHOW data_directory. in a UNIX like OS (eg: Mac) /Library/PostgreSQL/9.4/dataGo inside the base folder in the data directory which has all the database folders: /Library/PostgreSQL/9.4/data/base
Find the database folder name by running (Gives an integer. This is the database folder name):
Find the table file name by running (Gives an integer. This is the file name):
This is a binary file. File details such as size and creation date time can be obtained as usual. For more info read this SO thread
Everyone already answered but just for the latest updates. If you want to know where all the configuration files reside then run this command in the shell
On Mac: /Library/PostgreSQL/9.0/data/base
The directory can't be entered, but you can look at the content via: sudo du -hc data
I'd bet you're asking this question because you've tried pg_ctl start and received the following error:
Adware Removal Tool For Mac
pg_ctl: no database directory specified and environment variable PGDATA unset
Postgres Admin Tool Pgadmin
In other words, you're looking for the directory to put after -D in your pg_ctl start command.
In this case, the directory you're looking for contains these files.
You can locate it by locating any of the files and directories above using the search provided with your OS.
For example in my case (a HomeBrew install on Mac OS X), these files are located in /usr/local/var/postgres. To start the server I type:
... and it works.
On Windows, the PGDATA directory that the PostgresSQL docs describe is at somewhere like C:Program FilesPostgreSQL8.1data. The data for a particular database is under (for example) C:Program FilesPostgreSQL8.1database100929, where I guess 100929 is the database number.
Postgresql Mac Os
picmate's answer is right. on windows the main DB folder location is (at least on my installation)
and not in program files.
his 2 scripts, will give you the exact directory/file(s) you need:
mine is in datname 16393 and relfilenode 41603
protected by QuentinMar 9 '12 at 7:20
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?