Re: [GENERAL] IDE for function/stored proc development.

Hi 2016-09-03 11:36 GMT+02:00 Tim Uckun : > Does anybody use an IDE for doing heavy duty stored proc development? > PGadmin is decent but I am looking for something better. > > I have tried jetbrains with the db browser plugin and on the surface it > seems like a good choice

Re: [GENERAL] IDE for function/stored proc development.

From: Tim Uckun Sent: Saturday, September 03, 2016 2:37 AM Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have been using the Datagrip app (from Jetbrains), from its beta release up through now v 2016.2 and

Re: [GENERAL] IDE for function/stored proc development.

I tried a bunch of different IDEs and editors, and the dev toolset that I finally settled on is as follows: Atom editor for all coding and refinement Jetbrains DataGrip for code execution and most DBA work PGAdmin for other DBA that I can't do in DG Gitkraken for version control and pushing

Re: [GENERAL] Filters not supported for LDAP authentication

On Wed, Aug 31, 2016 at 2:43 PM, Bastien Bodart wrote: > Hi, > > Is there any reason filters are not supported for search+bind LDAP > authentication? > There is no option to pass a filter in search+bind mode and > "ldapsearchattribute" parameter is even checked to

Re: [GENERAL] IDE for function/stored proc development.

On 09/03/2016 02:36 AM, Tim Uckun wrote: Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have tried jetbrains with the db browser plugin and on the surface it seems like a good choice but it's really buggy when

Re: [GENERAL] Upgrading using pg_dumpall

On Sat, 3 Sep 2016, Adrian Klaver wrote: No it says you are using the 9.4.5 version of psql to connect to a 9.3.4 server. psql is available independent of the server running. You will need to see if both servers are running by doing something like: Adrian, Yeah, that's what it said. :-(

Re: [GENERAL] Upgrading using pg_dumpall

On 09/03/2016 02:44 PM, Rich Shepard wrote: On Sat, 3 Sep 2016, Adrian Klaver wrote: No it says you are using the 9.4.5 version of psql to connect to a 9.3.4 server. psql is available independent of the server running. You will need to see if both servers are running by doing something like:

Re: [GENERAL] Upgrading using pg_dumpall

On Sat, 3 Sep 2016, Adrian Klaver wrote: Once you verify that the new instance is running and you can connect to it then: Shut down 9.3.4 using pg_ctl stop as user postgres. Started 9.5.4 as user postgres using 'pg_ctl start /var/lib/pgsql/9.5/data &'. psql -U some_user -d postgres -p

Re: [GENERAL] Upgrading using pg_dumpall

On 09/03/2016 02:19 PM, Rich Shepard wrote: Postgres-9.3.4 was built directly from the web site download source. It's installed in /usr/lib/postgresql/9.3.4/. Postgresql-9.4.5 was built from the SlackBuilds.org script and installed in /usr/lib/postgresql/9.4/. The bin/ subdirectory of the 9.4

Re: [GENERAL] Upgrading using pg_dumpall

On Sat, 3 Sep 2016, Adrian Klaver wrote: I am guessing this from before you managed to get the dump file to load and populate the appropriate tables with user information from the old Postgres instance. Could well be the case. Tomorrow will try removing all user-generated databases and

Re: [GENERAL] Upgrading using pg_dumpall

On 09/03/2016 04:16 PM, Rich Shepard wrote: On Sat, 3 Sep 2016, Adrian Klaver wrote: Or if you are fine running the 9.5 instance at port 5432, what happens if you do?: psql -d postgres -U some_user -p 5432 $ psql -d postgres -U rshepard -p 5432 Password for user rshepard: psql: FATAL:

Re: [GENERAL] Upgrading using pg_dumpall

On Sat, 3 Sep 2016, Adrian Klaver wrote: A question are you really using 9.4.5 or 9.5.4(the latest version of 9.5)? And if you want to use 9.4 I would say use the latest(9.4.9). Adrian, It is 9.4.5, but I have the source tarball for 9.5.4 in the build directory. If the above is a yes, any

Re: [GENERAL] Upgrading using pg_dumpall

On 09/03/2016 03:43 PM, Rich Shepard wrote: On Sat, 3 Sep 2016, Adrian Klaver wrote: A question are you really using 9.4.5 or 9.5.4(the latest version of 9.5)? And if you want to use 9.4 I would say use the latest(9.4.9). Adrian, It is 9.4.5, but I have the source tarball for 9.5.4 in the

[GENERAL] Upgrading using pg_dumpall

Postgres-9.3.4 was built directly from the web site download source. It's installed in /usr/lib/postgresql/9.3.4/. Postgresql-9.4.5 was built from the SlackBuilds.org script and installed in /usr/lib/postgresql/9.4/. The bin/ subdirectory of the 9.4 version has all the excutable files, but that

Re: [GENERAL] Upgrading using pg_dumpall

On Sat, 3 Sep 2016, Adrian Klaver wrote: Or if you are fine running the 9.5 instance at port 5432, what happens if you do?: psql -d postgres -U some_user -p 5432 $ psql -d postgres -U rshepard -p 5432 Password for user rshepard: psql: FATAL: password authentication failed for user

Re: [GENERAL] Upgrading using pg_dumpall

On 09/03/2016 04:01 PM, Rich Shepard wrote: On Sat, 3 Sep 2016, Adrian Klaver wrote: Once you verify that the new instance is running and you can connect to it then: Shut down 9.3.4 using pg_ctl stop as user postgres. Started 9.5.4 as user postgres using 'pg_ctl start

Re: [GENERAL] IDE for function/stored proc development.

I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres. On Sat, Sep

Re: [GENERAL] What limits Postgres performance when the whole database lives in cache?

On 3 September 2016 at 04:36, dandl wrote: > In any event, I am not backing his claims. I am simply asking: does anyone > have any facts to support or refute his 96% claim as applied to Postgres? If that is scientific research he will publish evidence. If not, its just words

[GENERAL] IDE for function/stored proc development.

Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have tried jetbrains with the db browser plugin and on the surface it seems like a good choice but it's really buggy when working with procs. I also tried datagrip by