Re: [GENERAL] Error Upgrade PostgreSQL 9.4 to 9.5 in Debian - Solved

Em 28-08-2016 00:08, Tom Lane escreveu: Edson Analista writes: I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting the below error, what could be wrong? I think your problem is that you're using fancy quotes instead of plain ASCII single quotes in your pg_upgrade command lin

Re: [GENERAL] Error Upgrade PostgreSQL 9.4 to 9.5 in Debian

Edson Analista writes: > I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting > the below error, what could be wrong? I think your problem is that you're using fancy quotes instead of plain ASCII single quotes in your pg_upgrade command line. Those are getting taken as argument

[GENERAL] Error Upgrade PostgreSQL 9.4 to 9.5 in Debian

Good night I'm trying to Upgrade PostgreSQL to 9.4 9.5 in Debian 8, I am getting the below error, what could be wrong? Command that I used to do the pg_upgrade /usr/lib/postgresql/9.5/bin/pg_upgrade -b /usr/lib/postgresql/9.4/bin/ \-B /usr/lib/postgresql/9.5/bin/ \-d /var/lib/postgresql/9.4/

Re: [GENERAL] How to retrieve jsonb column through JDBC

Unfortunately JSONB is output in text. So this is the way it is done. Dave Cramer da...@postgresintl.com www.postgresintl.com On 27 August 2016 at 06:39, Alexander Farber wrote: > Hello, > > what do you use to retrieve a jsonb column using JDBC? > > I have tried > > Object last_tiles =

[GENERAL] How to retrieve jsonb column through JDBC

Hello, what do you use to retrieve a jsonb column using JDBC? I have tried Object last_tiles = rs.getObject("last_tiles"); and the resulting Object seems to be a String. Then I have called (using Jetty JSON class here): Object last_tiles = JSON.parse(rs.getString("last_tiles"