[pgadmin-support] Removing pg_trgm Extension - Upgraded from 9.1 to 9.5

2017-01-06 Thread Chuck Reed
sion pg_trgm; ERROR: function "set_limit" already exists with same argument types We haven't run into this issue before and I am looking for advice on how to proceed. Should we just manually drop all of the tables associated with pg_trgm and then attempt to use CREATE EXTENSION again? An

Re: [pgadmin-support] pgAgent - Log error when running

2006-08-02 Thread Chuck
local machine? I even tried the command su - postgres to make sure the postgres account was not corrupted. It is fine. Chuck ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if

Re: [pgadmin-support] pgAgent - Log error when running

2006-08-02 Thread Chuck
ident sameuser My installation should be a standard installation. I up until now, I have not touched the postgres account configuration. This is not a production system yet and I have full control over the system. Chuck ---(end of broadcast

Re: [pgadmin-support] pgAgent - Log error when running

2006-08-02 Thread Chuck
know this is not the suggested method for security reasons. Any idea what is wrong with the postgres account that woud not allow it to be used? Chuck ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [pgadmin-support] pgAgent - Log error when running

2006-08-02 Thread Chuck
postgres ec LOG: could not receive data from client: Connection reset by peer *** Chuck ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[pgadmin-support] pgAgent - Log error when running

2006-08-02 Thread Chuck
test job. The job indicates that it has never run and it is not currenlty running. Any assistance would be appreciated. Chuck ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail