How to create Server in Postgresql with port other than 5432?

Asked

Viewed 1,643 times

1

It is possible to create a server within the Postgresql database with a port other than 5432 ?

It is possible to have Server1: Postgresql at port 5432 and Server2: Test at gate 5433 ??

mysql sql postgresql postgresql-administration

1 answer

1


Change the file:

/etc/init.d/postgresql-9.3

The line:

PGPORT=5432

Then recharge the service:

service postgresql-9.3 restart
service postgresql-9.3 reload

  • I’m sweating windows! How would it look ? And detail I’m using ordinary user account !

  • And which file should I change ???

  • In windows I do not know, but if it is the same idea of linux you can look in services.Msc

  • Which file should I change ?

  • Why don’t you create different users, and grant permissions to a particular bank? It’s better than creating two sessions with different ports not?

  • How do I do that ?

  • It’s a lot to explain here, but you have this link here: http://www.devmedia.com.br/gerenciando-usuarios-e-permissoes-no-postgresql/14301

Show 2 more comments

Browser other questions tagged mysql sql postgresql postgresql-administration

You are not signed in. Login or sign up in order to post.