postgresql version won't change from default

Question

mac os x lion 10.7.4

psql --version -> psql (PostgreSQL) 9.0.5

I want to install latest version and run my rails app with it.

I do

brew install postgresql

it is installed here: /usr/local/Cellar/postgresql/9.1.4  

initdb /usr/local/var/postgres

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

I get:

pg_ctl: another server might be running; trying to start server anyway

running postgres --version

 -> 9.1.4

postgres -p 5433

 postgres does not know where to find the server configuration file.
 You must specify the --config-file or -D invocation option or set the PGDATA environment variable.

Craig Ringer · Accepted Answer · 2012-10-14 04:18:40Z

5

Edit /usr/local/var/postgres/postgresql.conf and change the port directive to use a different port number like 5433. Then start the new Pg instance as you did before.

You can now connect to the 9.1 instance by specifying a different port in your Rails configuration.

answered Oct 14, 2012 at 4:18

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Benamir Over a year ago

i changed the port and ran the server again but its not changing. can you please give me a bit more details on how to do this.

Craig Ringer Over a year ago

@Beamon ... did you change your rails setup to connect to the new port in database.yml?

Benamir Over a year ago

I'm not even connecting to the 9.1.4 instance yet... after I change the conf file to port # to 5433 and save. Starting the pg instance is not connecting to the right instance. Don't I need to connect to the right instance before I worry about my database.yml and rails configuration?

Craig Ringer Over a year ago

@Beamon Connecting with what? Do you mean psql? Struggling to understand your comment. You need to (a) Start the new Pg on a different port; and (b) connect to it by specifying the new port. For psql that'd be psql -p 5433 for example.

Craig Ringer Over a year ago

@Beamon Run the version of psql that was installed by the new PostgreSQL. You may need to set your PATH or use an explicit path. To get the version of the server you're connected to use select version();

|

Alvaro Rodriguez Scelza · Accepted Answer · 2020-08-19 20:53:43Z

5

In MAC:

brew link --overwrite -f [email protected]

will change default psql version on terminal psql command.

You will also find all postgresql version folders in /usr/local/Cellar/

Examples:

/usr/local/Cellar/postgresql/12.3_4

/usr/local/Cellar/[email protected]

answered Aug 19, 2020 at 20:53

Alvaro Rodriguez Scelza

4,2743 gold badges37 silver badges57 bronze badges

Collectives™ on Stack Overflow

postgresql version won't change from default

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related