Of course, each instance would listen on its own TCP/IP port.īelow query will help to find postgres configuration file. Note that it is possible, though not very frequent, to run two instances of the same PostgreSQL server (same binaries, different processes) that serve different "clusters" (data directories). You can usually see the running server with something like this: ~]# ps auxw | grep postgres | grep -D If you install from source, the default is /usr/local/pgsql/data:īesides, an instance of a running PostgreSQL server is associated to one cluster the location of its data directory can be passed to the server daemon (" postmaster" or " postgres") in the -D command line option, or by the PGDATA environment variable (usually in the scope of the running user, typically postgres). The location of the data directory depends on the distribution. The " directory where postgresql will keep all databases" (and configuration) is called "data directory" and corresponds to what PostgreSQL calls (a little confusingly) a " database cluster", which is not related to distributed computing, it just means a group of databases and related objects managed by a PostgreSQL server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |