Re: Altering multiple column types

On Fri, Aug 2, 2019 at 7:42 AM Bharanee Rathna wrote: > > Hi, > > I'm encountering an issue altering multiple column types in a single ALTER > TABLE > > psql (12beta2, server 11.4) it is working on my 11.4 with psql 11.4. Could it be a problem of psql version 12? Can you try again with a psql "s

Altering multiple column types

Hi, I'm encountering an issue altering multiple column types in a single ALTER TABLE psql (12beta2, server 11.4) Type "help" for help. test=# create table users(id serial primary key, name varchar(255), age int, email varchar(255)); CREATE TABLEtest=# create index users_name_idx on users(name); C

Re: Linux Mint - cannot find auto_explain extension

Hi, On Thu, Aug 1, 2019 at 7:53 PM Keith Roberts wrote: > > postgres=# CREATE EXTENSION auto_explain; > ERROR: could not open extension control file > "/usr/share/postgresql/9.5/extension/auto_explain.control": No such file > or directory > postgres=# > > Does anyone have any idea what package I

Linux Mint - cannot find auto_explain extension

Hi All, I'm running Linux Mint 18 Sarah and have installed PostgreSQL 9.5.18 but cannot load the auto_explain extension. postgres=# SELECT * from pg_extension; -[ RECORD 1 ]--+ extname    | plpgsql extowner   | 10 extnamespace   | 11 extrelocatable | f extversion | 1.0 extc

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 9:05 AM, Daniele Varrazzo wrote: On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: Yeah the requirements file shows psycopg2-2.8: https://github.com/postgres/pgadmin4/blob/master/requirements.txt The issue(I'm assuming) is: http://initd.org/psycopg/articles/2019/04/04/psycopg-28-

Re: PGAdmin4.11.1 on Ubuntu 18.04

On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver wrote: > Yeah the requirements file shows psycopg2-2.8: > https://github.com/postgres/pgadmin4/blob/master/requirements.txt > > The issue(I'm assuming) is: > > http://initd.org/psycopg/articles/2019/04/04/psycopg-28-released/ > "Added table_oid and tab

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 01/08/2019 16:32, Tony Shelver wrote: The article at stackoverflow is here Thanks for the link! The solution given in one of the comments there worked for me (Debian 9): - Install pip3 if needed: su

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:28 AM, Tony Shelver wrote: Thanks for the replies: the version is PG11.4. I tried to uninstall pgAdmin4, then install psycopg 2.8 via pip, then reinstall pgadmoin4 again using the Synatpic / Ubunto package manager, but it just installs pscopg2.7 over the top. If you are insta

Re: compressing network packets

On Thu, Aug 1, 2019 at 5:43 PM farjad.farid wrote: > Under windows environment, is there a way of compressing the network packet > reaching postgresql server? You'll need to explain a bit more. You have windows, I assume for either client, server or both, and you have a pg server, on an unespeci

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:28 AM, Tony Shelver wrote: Thanks for the replies: the version is PG11.4. I tried to uninstall pgAdmin4, then install psycopg 2.8 via pip, then reinstall pgadmoin4 again using the Synatpic / Ubunto package manager, but it just installs pscopg2.7 over the top. What repo are you

compressing network packets

Under windows environment, is there a way of compressing the network packet reaching postgresql server? Many thanks.

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 8:34 AM, Ron wrote: I think the real question is "how do I make pgadmin4 use the locally installed psycopg instead of the system version?" Yeah the requirements file shows psycopg2-2.8: https://github.com/postgres/pgadmin4/blob/master/requirements.txt The issue(I'm assuming) is: h

Re: PGAdmin4.11.1 on Ubuntu 18.04

I think the real question is "how do I make pgadmin4 use the locally installed psycopg instead of the system version?" On 8/1/19 10:32 AM, Tony Shelver wrote: The article at stackoverflow is here On Thu

Re: PGAdmin4.11.1 on Ubuntu 18.04

The article at stackoverflow is here On Thu, 1 Aug 2019 at 17:28, Tony Shelver wrote: > Thanks for the replies: the version is PG11.4. > > As for needing to upgrade: I just want to fix the problem. This

Re: PGAdmin4.11.1 on Ubuntu 18.04

Thanks for the replies: the version is PG11.4. As for needing to upgrade: I just want to fix the problem. This was a working environment until I updated pgAdmin4. The fix suggested on Stackoverflow was to move to psycopg2 2.8, but it doesn't seem to be possible. If there is another fix that an

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 7:39 AM, Tony Shelver wrote: I am getting an 'able oid' when querying any tables using the Query tool. When using the view / edit data option, everything works fine. Should have asked in previous post: What Postgres version(s)? I came across this <<< The problem is due to python3

Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 7:39 AM, Tony Shelver wrote: I am getting an 'able oid' when querying any tables using the Query tool. Can you show the actual entire error message? More below. When using the view / edit data option, everything works fine. I came across this <<< The problem is due to python3-ps

PGAdmin4.11.1 on Ubuntu 18.04

I am getting an 'able oid' when querying any tables using the Query tool. When using the view / edit data option, everything works fine. I came across this <<< The problem is due to python3-psycopg2. The latest pgadmin4 version requires psycopg2-2.8. But if you're on Debian/Ubuntu stable, apt ins

Re: adding more space to the existing server

On 7/31/19 3:21 PM, Julie Nishimura wrote: Hello postgres folks, We're tossing around the idea of upgrading a replicated postgres cluster (37 dbs) by breaking the replication, adding different size (larger) data disks to the hot-spare, then turning replication back on, letting it fully popula

Re: Cursors for PGJDBC queries

Rashmi V Bharadwaj schrieb am 01.08.2019 um 09:10: > I am trying to set the fetch size for my ResultSet to avoid Out of > Memory exception. I have created the Statement with > ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY and > ResultSet.HOLD_CURSORS_OVER_COMMIT and I've also disabled aut

Re: Cursors for PGJDBC queries

On Thu, Aug 1, 2019 at 9:30 AM Luca Ferrari wrote: > Hard to say without more information. Could it be something you need > to set on the jvm like sorry, I was intended to write -Xms256m -Xmx1024m to adjust the jvm memory limits. Again I believe that the jdbc mailing list is the right place to as

Re: Cursors for PGJDBC queries

On Thu, Aug 1, 2019 at 9:10 AM Rashmi V Bharadwaj wrote: > I am trying to set the fetch size for my ResultSet to avoid Out of Memory > exception. I have created the Statement with ResultSet.TYPE_FORWARD_ONLY, > ResultSet.CONCUR_READ_ONLY and ResultSet.HOLD_CURSORS_OVER_COMMIT and I've > also di

Cursors for PGJDBC queries

Hi,I am trying to set the fetch size for my ResultSet to avoid Out of Memory exception. I have created the Statement with ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY and ResultSet.HOLD_CURSORS_OVER_COMMIT and I've also disabled auto commit as mentioned in the link Getting results based