PostgresInstall

We used a custom installation of postgres for 2 reasons.

1. We required UUID support as our target system is C# .net which uses this.
2. We found MS supports very long identifier names used in the code.

Here are the steps of the install:

1. Download and install ossp-uuid with —prefix=/usr ( see: UsefulLinks )
2. Edit include/pg_config_manual.h and set NAMEDATALEN to 128
3. Configure Postgres: ./configure —with-ossp-uuid
4. cd to contrib/uuid-oosp and make ; make install
5. Place the oosp-uuid sql script in the database build directory

You may need to run initdb -D on your data directory if this is the first time.

If this seems a little vague, try building a vanilla postgres from the install instructions. This is just the modifications I made.

If this looks like it is in a foreign language, you may need to find someone who knows how to build a package from source.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License