Postgresql cluster initialization

SQL distributes pre-initialized catalog cluster but for postgresql we need initialize cluster using initdb and a network service account. It fails in few cases and causing bit of misery!

Can initi开发者_开发百科alize cluster ourselves and distribute pre-initialized cluster?

Thanks

---

The "cluster" (or data directory) depends on the operating system and the architecture. So a data directory that was initialized with initdb on a 32bit Linux will not work on a 64bit Windows.

But you don't need to do that. A service account is only necessary if you want to run PostgreSQL as a service.

You can easily use the ZIP distribution to install and start Postgres without the need for a full-fledge installation or a service account.

The steps to do so are:

1. Unzip the binaries
2. Run initdb pointing it to the directory where the database cluster should be created.
3. Run pg_ctl to start the server.

Note that the steps 2) and 3) must be run using the same user, otherwise the server will have no priviliges to write to the data directory.

These steps can easily be put into a batch file or shell script.

---

Hard to understand your question, but I think you are talking about the Windows installer for PostgreSQL. Right? What version, what installer, what about error messages, loggings, etc. ?

The installer can be found here.

SQL = database language, SQL Server = Microsoft database product