Posts

Postgresql System files and their uses

Image
The postmaster.opts File This postmaster.opts file sets the default invocation options for the postmaster program, which is the main PostgreSQL program. Typically, it will contain the full path to the postmaster program, a -D option to set the full path to the principal data directory, and optionally, a -i flag to enable network connections. The postmaster.opts options are listed in Table 11-5.  Table 11-5. postmaster Options Option   Description  -B          nbufs Sets the number of shared memory buffers to nbufs. -d           level Sets the level of debug information (level should be a number 1 through 5)               written to the server log. -D dir      Sets the database directory (/data) to dir. There is no default value. If no              -D option is set, the value of the environment variable PGDATA is used. -i           Allows remote TCP/IP connections to the database. -l           Allows secure database connections using the Se
Post a Comment
Read more

Installing Postgre SQL, Creating the DB and restoring the DB

Image
Installing PostgreSQL  DB Creation and Restore
Post a Comment
Read more

The Basics Of PostgreSQL UUID Data Type

Image
Summary : in this tutorial, you will learn about the PostgreSQL UUID data type and how to generate UUID values using a supplied module. Introduction to PostgreSQL UUID type UUID stands for Universal Unique Identifier defined by  RFC 4122  and other related standards. A UUID value is 128-bit quantity generated by an algorithm that make it unique in the known universe using the same algorithm. The following shows some examples of the UUID values: 1 2 3 40e6215d - b5c6 - 4896 - 987c - f30f3678f608 6ecd8c99 - 4036 - 403d - bf84 - cf8400f67836 3f333df6 - 90a4 - 4fda - 8dd3 - 9485d27cee36 As you can see, a UUID is a sequence of 32 digits of hexadecimal digits represented in groups separated by hyphens. Because of its uniqueness feature, you often found UUID in the distributed systems because it guarantees a better uniqueness than the  SERIAL  data type which generates only unique values within a single database. To stores UUID values in the PostgreS
Post a Comment
Read more