postgresql database server

By default, PostgreSQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home computer or from web server. Step # 1: Login over ssh if server is outside your IDC Login over ssh to remote PostgreSQL database server: $ ssh user@remote.pgsql.server.com Step […]

{ 37 comments }

Describes how to backup and restore postgresql database under Linux / UNIX operating system using pg_dump and psql commands.

{ 27 comments }