How to add uuid components to PostgreSQL in Linux

Step 4 of sourceetcprofile. Go to supostgres user psql-Upostgres-dmydblt; usrlocalpgsqlsharecontribuuid-ossp. SQL

Source/etc/profile step 4. Enter su postgres user psql-U postgres-d mydb lt;/usr/local/pgsql/share/contrib/uuid-ossp. SQL

Notes

1. find/-name uuid-ossp.so search to see if there is

If not. Click here to download and install uid-1.6.1.tar.gz. Note .. /Configure. The uuid-ossp.so file will exist in/usr/local/lib at this time

2. If an error is reported during postgresql installation.

Checking for uuid_export in-lossp-uuid... no
Checking for uuid_export in-luuid... no
Configure: error: library 'oss-uuid 'or 'uuid' is required for OSSP-UUID"
The UUID package is not installed. That is, the first step is not done well.
./Configure -- with-libxml -- with-ossp-uuid -- with-libs =/usr/local/lib -- with-nodes des =/usr/local/include

In this case, install.

3. Add component

Go to the cd post installation package directory/contrib/uuid-ossp/

Make & make install

4. Configure Environment Variables

/Etc/profile

PGLIB =/usr/local/pgsql/lib
PGDATA = $ HOME/data
PATH = $ PATH:/usr/local/pgsql/bin
MANPATH = $ MANPATH:/usr/local/pgsql/man
Export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH:/usr/local/lib
Export PGLIB PGDATA PATH MANPATH

Source/etc/profile

Step 4.

Enter su ipvs user

Psql-U postgres-d mydb </usr/local/pgsql/share/contrib/uuid-ossp. SQL where

Mydb is a self-built Database

A lot of code is lost.

,