tags:

views:

672

answers:

2

Hi, currently install pgsql is running on port 1486 now I want to change this port to 5433, So how I've proceed for this....?????
Thanx in advance..

+3  A: 

There should be a line in your postgresql.conf file that says:

port = 1486

Change that.

The location of the file can vary depending on your install options. On Debian-based distros it is /etc/postgresql/8.3/main/

Neall
+1  A: 

You can also change the port when starting up:

$ pg_ctl -o "-F -p 5433" start

Or

$ postgres -p 5433

More about this in the manual.

Frank Heikens