How to output psql to file

Filed in How-to | postgresql Leave a comment

FacebookTwitterGoogle+LinkedInTumblrShare

Application: PSQL
Operating System: Linux – Fedora Core 19 (Schrödinger’s Cat)
Architecture: x86_64

To write the psql to file.

, ,

How to enable timing and remove result pagination in psql

Filed in How-to | postgresql Leave a comment

Application: PSQL
Operating System: Linux – Fedora Core 19 (Schrödinger’s Cat)
Architecture: x86_64

To monitor execution time, set timing to on.
To remove result pagination (more), set pager to off.

, , , ,

Installing PgModeler 0.5.2 on Fedora Core 19

Filed in Data Modeler | Fedora Core | How-to | postgresql 1 Comment

Application: PgModeler 0.5.2
Operating System: Linux – Fedora Core 19 (Schrödinger’s Cat)
Architecture: x86_64

Step 1
Download the package.

Step 2
Extract the archive package.

The application will be located at /home/user/Apps/pgmodeler

Step 3
In order to make it run, you need to setup required environment variables.

Step 4
Required library.

Step 5
Run application.

pgmodeler052

, , , ,

Installing PgModeler 0.5.0 on Fedora Core 18

Filed in Data Modeler | Fedora Core | How-to | postgresql Leave a comment

Application: PgModeler 0.5.0
Operating System: Linux – Fedora Core 18 (Spherical Cow)
Architecture: x86_64

Step 1
Download the package.

Step 2
Copy and extract the archive.

The application will be extracted to /opt/pgmodeler-0.5.0

Step 3
Inorder to make it run, you need to setup environment path.

Step 4
Execute the application.


pgmodeler

, , ,

Installing PostgreSQL 9.2.4 on Fedora Core 18

Filed in Fedora Core | How-to | postgresql Leave a comment

Application: PostgreSQL 9.2.4
Operating System: Linux – Fedora Core 18 (Spherical Cow)
Architecture: x86_64

Step 1
Clean and re-cache package list in repositories.

Step 2
Install PostgreSQL 9.2.4 and pgAdmin 3. The package is available in fedora update repository.

Note:
Package from Fedora Update repository will install to /usr/bin/
Package from Postgresql92 repository will install to /usr/pgsql-9.2/bin/

Step 3
Initialise DB

Output

Important

Step 4
Start Server

Step 5
Test the database server

Note:
To allow username and password mode, edit pg_hba.conf
To allow listening on all adaoters, edit postgresql.conf

, ,

PostgreSQL Plus Advanced Server 9.2.1.3 on Fedora Core 18 – Part 1

Filed in Fedora Core | How-to | postgresql | Uncategorized Leave a comment

Application: PostgreSQL Plus Advanced Server 9.2.1.3
Operating System: Linux – Fedora Core 18
Architecture: x86_64

1. Download.
– Access to EnterpriseDB web site

– Register, login and download the file ppasmeta-9.2.1.3-linux-x64.tar.gz.
– Download path /home/user/Downloads/ppasmeta-9.2.1.3-linux-x64.tar.gz

2. Extract
– Open terminal.

– Extracted to /home/user/Downloads/ppasmeta-9.2.1.3-linux-x64

3. Install

Language Selection

License Agreement

User Authentication – Using EnterpriseDB account.

Installation directory – leave it as default

Components Selection

Additional Directories

Configuration Mode – Oracle Compatible

Password for enterprisedb user

Additional Configuration – Port. Locale and Sample

Server Utilization

Workload Profile

PgBouncer Configuration

Service Configuration

Summary

Installation Confirmation

Installation Progress

4. Set up environment path

5. Access database using psql client

, ,

TOP