postgresql 删除旧的版本9.5 并同时升级到9.6

sudo apt-get purge postgresql-9.5

On Ubuntu 14.04 I have done this to get the latest postgres:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

sudo apt-get upgrade

Then I installed version 9.4:

sudo apt-get install postgresql-9.4

However it seems I have now three versions:

sudo service postgresql stop

 * Stopping PostgreSQL 9.3 database server  [ OK ]

 * Stopping PostgreSQL 9.4 database server  [ OK ]

 * Stopping PostgreSQL 9.5 database server  [ OK ]

How can I keep only 9.4 and uninstall the other ones? Thanks

UPDATE:

As suggested in comments I have uninstalled 9.3 and 9.5.

But when I do this:

sudo service postgresql status

9.3/main (port 5432): down

9.4/main (port 5434): online

9.5/main (port 5433): down

So far so good, but when I switch to postgres:

sudo su postgres

and do a psql, I get an error:

psql: could not connect to server: No such file or directory

    Is the server running locally and accepting

    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

---------------------------------------------------------------------------------

Different versions of PostgreSQL are located in the packages postgresql-9.*.

So you should remove your two packages:

sudo apt-get purge postgresql-9.3 postgresql-9.5

Then you should remove unnecessary config folders:
```
rm -r /etc/postgresql/9.3/ /etc/postgresql/9.5
```
And from /var/lib/ folder if you have:
```
/var/lib/postgresql/*
```

I hope it will help you.

巴特西

postgresql 删除旧的版本9.5 并同时升级到9.6

最新文章

热门文章

巴特西

postgresql 删除旧的版本9.5 并同时 升级到9.6

最新文章

热门文章

postgresql 删除旧的版本9.5 并同时升级到9.6