I installed postgres on Mac OS X 10.6.x. When I ran for postgres database version:
psql --versionpsql (PostgreSQL) 9.1.1
contains support for command-line editing
When I checked for the version of the server:
psql -c "select version();" version
--------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.0.5 on x86_64-apple-darwin10.8.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3), 64-bit
(1 row)
So when I run
bash-3.2$ psql
psql (9.1.1, server 9.0.5)
WARNING: psql version 9.1, server version 9.0.
Some psql features might not work.
I am not sure what those features are. These versions are conflicting. I am new to using postgres so I dont know how to upgrade just the postgres server. I tried to search for something online but did not find much help. I don't want to uninstall and reinstall postgres. Is there anyway I could use them both together without them conflicting? Or just upgrade the server to the same version as database?
Edit:
which psql
/opt/local/lib/postgresql91/bin//psql
which postgres
/opt/local/lib/postgresql91/bin//postgres
ps -eaf|grep postgres
0 60 1 0 0:00.07 ?? 0:00.09 /opt/local/bin/daemondo --label=postgresql90-server --start-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.postgresql90-server/postgresql90-server.wrapper restart ; --pid=none
103 3971 3967 0 0:00.69 ?? 0:01.17 postgres: writer process
103 3972 3967 0 0:00.67 ?? 0:00.88 postgres: wal writer process
103 3973 3967 0 0:00.18 ?? 0:00.23 postgres: autovacuum launcher process
103 3974 3967 0 0:00.19 ?? 0:00.21 postgres: stats collector process
0 3616 2726 0 0:00.04 ttys000 0:00.06 su postgres
103 3967 3619 0 0:00.23 ttys000 0:00.34 postgres -D /usr/local/pgsql/data
0 4559 4055 0 0:00.03 ttys001 0:00.05 su postgres
103 5922 4560 0 0:00.01 ttys001 0:00.01 grep postgres
Thank you.
You need to check the postgresql. conf config file. If you want to run both instances at the same time then they will need to be run on different ports otherwise they will conflict. The default is 5432, change this for one of the DB's.
Major versions usually change the internal format of system tables and data files. These changes are often complex, so we do not maintain backward compatibility of all stored data.
1 Answer. Can postgresql and mysql run together in the same machine ? yes.
I suppose that you've already had PostgreSQL installed before. Please, confirm this, 'cos in this case you will have to upgrade your database. This is important step, it is not possible to just upgrade the software.
Please, try stopping currently running server. First, check the source of currently running PostgreSQL:
sudo launchctl list | grep -Ei "macports|postgres"
Then perform:
sudo launchctl unload -w <OldPostgreSQL.plist>
and start a new server like this:
sudo launchctl load -w <NewPostgreSQL.plist>
I would expect new plist to be/Library/LaunchDaemons/org.macports.postgresql91-server.plist
.
In case you need to upgrade:
pg_dump
.initdb
in the new PGDATA
folder.Here's a small description I've came across on the subject. And this is the official PostgreSQL documentation on upgrading between major releases.
Mine was a homebrew install and here's what I did (brought me to a functioning psql with no version issues) -- I'm trying to install KyngChaos's mac build of postgresql
step 0 (already did):
brew uninstall postgresql
step1
which psql
=> "locationpath" (in my case, /usr/bin/psql)
sudo rm "locationpath"
step2
#inside ~/.bash_profile
export PATH=/usr/local/pgsql-9.3/bin:$PATH
step3
psql
#works
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With