Installing Postgre SQL, Creating the DB and restoring the DB

Installing PostgreSQL 















DB Creation and Restore










Comments

Post a Comment

Popular posts from this blog

Postgresql Book References

Image
PostgreSQL -- Up and Running -- 1st Edition Url: https://drive.google.com/open?id=1cfZtwvN6MZDYxgSWR0cXxdgwd4TtghtG PostgreSQL -- Up and Running -- 2nd Edition Url: https://drive.google.com/open?id=1p6jNG6wyro-svzXfIKRGSsNoZddA4akh Beginning Databases with PostgreSQL -- From Novice to Professional (Beginning From Novice to Professional)  -- 2nd Edition Url: https://drive.google.com/open?id=1uQElel4BoIXGxqdqmYVbWToyYoRpoljA
Read more

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    ...
Read more