Manage Tablespaces
Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects can be stored. Once created, a …
Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects can be stored. Once created, a …
Hivelocity supports Microsoft SQL server AKA MSSQL , PostgreSQL , and MYSQL.
Turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the …
In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL. Because of the way that the kernel implements memory overcommit, …
It is advisable to run PostgreSQL under a separate user account. This user account should only own the data that is managed by the server, …
The following are the commands for installing PostgreSQL from source, refer to the INSTALL file for explanation of each: ./configure gmake su gmake install adduser …
Overview The Service Manager area enables you to start and stop available services on your server. The following services are available: antirelayd – The …
You can restart any of the available services on the web server at any time. You can restart the following services: Mail Server (Exim) DNS/Name …
Following commands also useful to take backup and restore of simple (not contains large objects) postgresql database. pg_dump mydb > db.out To restore database psql …
Postgresql Using following command you can take backup of postgresql database. # pg_dump -u -C -f backupfile.sql database_name You can restore pgsql database using following …
Installing Postgresql – HOWTO cPanel requires Postgresql 7.3.x or later. 7.2.x will not work. =========================================== Step 1 =========================================== Upgrade to cPanel 7.4.0 build 45 or …