I need to use the new jsonb field in postgres so I decided to upgrade to 9.5 in my ununtu 16.04 LTS. I followed this tutorial , but when it gets to the command pg_upgradecluster 9.3 main, I get the error that cluster configuration already exists. I checked other tutorials and found that I could get the list of clusters with pg_lsclusters. But the command always shows only the 9.3 cluster. Any attempt to create the 9.5 cluster always results to cluster configuration already exists. I purged the 9.5 and installed again multiple times but the same result. At last I decided to purge all the postgres installations I have after backing up my 9.3 cluster with pg_dumpall.
Now I have decided to install the 9.5 freshly but I still get the same thing. When I install pg_lsclusters shows nothing and after starting postgres psql always returns 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"?
Right now I'm so tired and frustrated. Please if anyone has any possible solution or suggestion, help
Upgrading from postgres-9.3 to postgres-9.5
850 Views Asked by Ken At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in POSTGRESQL-9.3
- Query to Insert and update records
- Compare fields Where One is Similar to Part of Another in Postgres sql
- Postgres, unable to usedistinct in json_aggr
- Spring R2DBC Compatibility with Postgres
- How do i set role with Supabase?
- how to stop stream clustering on PostgreSQL
- Need help configuring PostgreSQL connection to behave like MySQL: Connect to server without auto-selecting default database
- Postgresql query cast timestamp without time zone adding a second to passed time
- Indicate a schema within an execution format
- XML validation using XSD in postgres procedure
- what is the Proper way to insert json into postgresql table?
- Problem in connection fhirbase to postgres
- pgadmin 4 connection failed Issue. Connection to server at "localhost (::1), port 5432 failed
- pg_basebackup: directory "/u01/edb/as9.6/data/edbdata/syno/DATA/ascii_data" exists but is not empty
- postgres query with calculate before agregate
Related Questions in UBUNTU-16.04
- Store website username/password on Elinks for Ubuntu
- Having issues joining my kubernetes worker noed to a controller node
- Request Content-Length 198664571 exceeds the configured limit of 31457280
- ASP.NET Core app does not redirects to ssl port on nginx + ubuntu
- Error in installing imagick due to dependencies issue
- How can I build python3.11 with ssl for ubuntu 16.04
- GTK/GDK/X11 Issue With Window Titles Larger Than Window on Ubuntu 16.04
- Write multiple commands in a row to WSL ubuntu terminal
- Error installing python3.7 on ubuntu 16.04
- I am trying to install Ubuntu OS and I encounter an input/output error while installing the system
- How do I get the data I extract from NetCDF using NCO to be in correct format?
- Web server not using TLS 1.2 when connecting to Amazon SES via SMTP
- Why is gem telling me the current ruby version is 2.5.0 when it's not?
- Not able Unlock Window Vm which is configured inside the ubuntu server QEMU/KVM
- Docker apt-get update fails during building phase
Related Questions in POSTGRESQL-9.5
- Compare fields in two tables
- Query to Insert and update records
- Compare fields Where One is Similar to Part of Another in Postgres sql
- ERROR: invalid string in message when querying into a PostgreSQL database
- Why I could setup SSL connection to RDS without a certificate file?
- Select and insert with counter
- Spring R2DBC Compatibility with Postgres
- Will the pg_stat_statements view show old data if there is no transaction going on in the database?
- PostgreSQL 9.5: multiple updates to a row by the same query is not allowed
- Postgres : multiple updates to a row by the same query is not allowed
- Need help configuring PostgreSQL connection to behave like MySQL: Connect to server without auto-selecting default database
- Postgresql Return Whether Upsert Query INSERTed a New Row or UPDATEd one
- How can I improve the speed of materialized view refreshes and reduce CPU usage
- PHP errors on Windows Server
- using a values returned from a function in another query inside a function
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The problem seemed to be from the version 9.5 in the postgres repositories. I installed 9.6 and everything worked like magic. Had I known there was a stable 9.6 earlier, I wouldn't have wasted 6 hours of my life in something I could have done for 10 minutes. Anyway, I'm happy I have have a working postgres with jsonb field