Re: E: Package 'pgAdmin4' has no installation candidate ?

2018-07-12 Thread richard coleman
Thanks, removing and re-adding the repo seems to have done the trick. rik. On Wed, Jul 11, 2018 at 7:36 PM, Richard Greenwood < richard.greenw...@gmail.com> wrote: > You should add the apt.postgresql.org repository: > > sudo nano /etc/apt/sources.list.d/pgdg.list > # add the following line:

pgAgent v4.0.0 Released

2018-07-12 Thread Dave Page
The pgAdmin Development Team are pleased to announce the release of pgAgent v4.0.0. pgAgent is a job scheduler for PostgreSQL; for more information please see the documentation included as part of the pgAdmin documentation at https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html. Download (sourc

Re: pgAgent v4.0.0 Released

2018-07-12 Thread Eugene Wang
This is awesome. Always have interests to use pgAgent; however, the official documentation about installing is obscure and stop me from getting into it... I honestly cannot get any clue about steps I should do from this https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html link. Maybe installing

Re: pgAgent v4.0.0 Released

2018-07-12 Thread Dave Page
Hi On Thu, Jul 12, 2018 at 3:12 PM, Eugene Wang wrote: > This is awesome. Always have interests to use pgAgent; however, the > official documentation about installing is obscure and stop me from getting > into it... I honestly cannot get any clue about steps I should do from this > https://www.p

Cannot install pgAdmin 4.1 in Windows Server 8 R2

2018-07-12 Thread Edson Richter
After install, whenever I try to start pg Admin 4 3.1, I get an error about VC runtime dll not be found. "Program cannot be started because VCRUNTIME140.dll is missing in your computer. Try to reinstall to solve this problem" (my translation). What I've did already: - Uninstall pgAdmin 4 3.1 an

Re: Cannot install pgAdmin 4.1 in Windows Server 8 R2

2018-07-12 Thread Dave Page
On Thu, Jul 12, 2018 at 3:53 PM, Edson Richter wrote: > After install, whenever I try to start pg Admin 4 3.1, I get an error > about VC runtime dll not be found. > > > > “Program cannot be started because VCRUNTIME140.dll is missing in your > computer. Try to reinstall to solve this problem” > >

pgAdmin4 missing object level restores

2018-07-12 Thread richard coleman
Hi, In pgAdmin4 there doesn't appear to be a way to do an object level (i.e. certain schema, or certain table, etc.) restore. In pgAdmin3 you could list the objects in a .backup file and then select just the objects you wanted to restore. Is this a bug, an oversight, or by design? If the latte

RES: Cannot install pgAdmin 4.1 in Windows Server 8 R2

2018-07-12 Thread Edson Richter
De: Dave Page Enviada em: quinta-feira, 12 de julho de 2018 12:15 Para: Edson Richter Cc: Pgadmin-Support@Postgresql. Org Assunto: Re: Cannot install pgAdmin 4.1 in Windows Server 8 R2 On Thu, Jul 12, 2018 at 3:53 PM, Edson Richter mailto:edsonrich...@hotmail.com>> wrote: After install, when

RES: Cannot install pgAdmin 4.1 in Windows Server 8 R2 (SOLVED)

2018-07-12 Thread Edson Richter
De: Edson Richter Enviado:quinta-feira, 12 de julho de 2018 13:17 Para: Dave Page Cc:Pgadmin-Support@Postgresql. Org Assunto: RES: Cannot install pgAdmin 4.1 in Windows Server 8 R2 De: Dave Page Env

Query Tool Initialize Error

2018-07-12 Thread Duffey, Blake
Launching pgAdmin 4 ver 3.1 against PG 9.5 User selects servers, database, schema Clicks Tools | Query Tools Is immediately hit with 'Query Tool Initialize Error' Thanks

pgadmin4 + SSH Tunnel

2018-07-12 Thread Daryl Roche
Hello, I have no problem connecting without SSL to my postgresql server utilizing an ssh tunnel, but if I try to enable SSL for the postgresql db connection with verify-ca it doesn't work. I'm supplying the root certificate, but we don't use client certificates for authentication, only username

401 Unauthorized on first run of pgadmin4

2018-07-12 Thread John Little
I've today tried to install pgadmin4 on Kubuntu 18.04 according to the instructions at https://wiki.postgresql.org/wiki/Apt Running pgadmin4 produces a 401 Unauthorized page in firefox. In the terminal it shows Python path: "/usr/lib/python3/dist-packages" Python Home: "" Webapp path: "/usr/

Re: 401 Unauthorized on first run of pgadmin4

2018-07-12 Thread Khushboo Vashi
On Fri, Jul 13, 2018 at 9:37 AM, John Little wrote: > I've today tried to install pgadmin4 on Kubuntu 18.04 according to the > instructions at > > https://wiki.postgresql.org/wiki/Apt > > Running pgadmin4 produces a 401 Unauthorized page in firefox. > > By using the pgAdmin 4 Tray Icon, you can b

Re: Query Tool Initialize Error

2018-07-12 Thread Khushboo Vashi
This issue is already reported on Windows. Ref: https://redmine.postgresql.org/issues/3433 Are you on Windows? If yes then which version? Please enable logging and provide the logs. To enable logging ref: https://www.pgadmin.org/faq/#8 On Fri, Jul 13, 2018 at 1:20 AM, Duffey, Blake wrote:

Re: pgAdmin4 missing object level restores

2018-07-12 Thread Khushboo Vashi
On Thu, Jul 12, 2018 at 9:37 PM, richard coleman < rcoleman.ascen...@gmail.com> wrote: > Hi, > > In pgAdmin4 there doesn't appear to be a way to do an object level (i.e. > certain schema, or certain table, etc.) restore. In pgAdmin3 you could > list the objects in a .backup file and then select

Re: pgadmin4 + SSH Tunnel

2018-07-12 Thread Akshay Joshi
Hi Daryl On Fri, Jul 13, 2018 at 5:35 AM, Daryl Roche wrote: > Hello, > > I have no problem connecting without SSL to my postgresql server utilizing > an ssh tunnel, but if I try to enable SSL for the postgresql db connection > with verify-ca it doesn't work. I'm supplying the root certificate,