[pgadmin-support] PgAdmin3, SSL certificate connections refused

2015-08-28 Thread Gabriel E . Sánchez Martínez
Hi, I posted the following to pgadmin-hackers several weeks ago but have not received any replies. Perhaps I posted to the wrong list, and hopefully pgadmin-support is the right one. Has any once else experienced the same issue? Thanks, Gabriel On 08/03/2015 04:37 PM, "Gabriel E. Sánchez

[pgadmin-support] pgScript Scripting Language - catch exception

2015-08-28 Thread Sergey Grinko
No exception is generated when inserting a duplicate. Sample: CREATE DATABASE test; CREATE TABLE test ( id serial NOT NULL, label character varying(50), CONSTRAINT test_pkey PRIMARY KEY (id) ); Then run the 3 commands as one PgScript: *insert into test (id, label) values(1, '1');* *insert i

[pgadmin-support] Define two factor authentication for Postgresql Server

2015-08-28 Thread Nima Azizzadeh
Hello, I'm going to create two factor authentication for pgadmin server... I'm using postgresql 9.4 with pgadmin III on Linux Mint 17.2 32bit... I already have 1 password authentication but For better security, I just want to force 2 of them. The authentication factors could be any things(what user

Re: [pgadmin-support] Log verbosity setting (client)

2015-08-28 Thread Dave Barter
Yes, to be clear the logs are working as I expect on the server. I understand that this needs to be set client side as well. In sql you would do this via:- \set VERBOSITY terse I need to do the same in pgadmin > On 28 Aug 2015, at 13:17, Sanket Mehta wrote: > > Hi Dave, > > After setting t

Re: [pgadmin-support] Log verbosity setting (client)

2015-08-28 Thread Sanket Mehta
Hi Dave, After setting the log_error_verbosity in postgres.conf have you reload the configuration of that server? Regards, Sanket Mehta Sr Software engineer Enterprisedb On Fri, Aug 28, 2015 at 5:30 PM, Dave Barter wrote: > > On 28 Aug 2015, at 12:58, Sanket Mehta > wrote: > > Hi Dave, > > Y

Re: [pgadmin-support] pgAdmin III Version 1.20.0 error on ubuntu x64

2015-08-28 Thread Franklin Byaruhanga
Hi Sanket i followed the steps bellow: http://www.postgresqltutorial.com/postgresql-restore-database/ I also tried with pgsql and pg_restore didn't get any error. i then changed to a lower version of PGADMIN3 1.18 still didn't get any error. i then built the new version 1.22.0 Alpha 2 from the gi

Re: [pgadmin-support] Log verbosity setting (client)

2015-08-28 Thread Dave Barter
> On 28 Aug 2015, at 12:58, Sanket Mehta wrote: > > Hi Dave, > > You can change the logging settings for pgadmin using below mentioned menu: > > File -> options -> Logging > > There is a option to set No logging to prevent log messages of pgadmin. > Thanks, but this is not what I want. I ne

Re: [pgadmin-support] Log verbosity setting (client)

2015-08-28 Thread Sanket Mehta
Hi Dave, You can change the logging settings for pgadmin using below mentioned menu: File -> options -> Logging There is a option to set No logging to prevent log messages of pgadmin. Regards, Sanket Mehta Sr Software engineer Enterprisedb On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter wrote:

Re: [pgadmin-support] pgAdmin III v 1.20.0 and Slony-I v2.2.4 and Postgresql v9.4.4

2015-08-28 Thread Aurelio Campa (ERA)
Sadly not. I configured it manually. I did not use Slony in the end as one of its requirements is that every table should have a primary key. I did not have control over the database so in the end I just used the built in PostgreSQL replication. On 27/08/2015 17:39, "snake77se" wrote: >Hello Au

Re: [pgadmin-support] pgAdmin III Version 1.20.0 error on ubuntu x64

2015-08-28 Thread Sanket Mehta
Hi Franklin, Can you please provide me the steps you have performed from the beginning to restore the database?? Regards, Sanket Mehta Sr Software engineer Enterprisedb On Thu, Aug 27, 2015 at 10:51 AM, Franklin Byaruhanga wrote: > Hi pgadmin-support > > I get the following pgAdmin III error