Hello
On 09/04/2016 01:16 AM, 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:
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-r
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: passw
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 "rshepar
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 /var/lib/pgsql/9.5/dat
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 5442
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
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
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:
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. :-(
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 v
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
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 work
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 codeba
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 lov
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 prevent filter injection.
> "lda
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 3,
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 but it's really buggy
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 j
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 and no refutation i
20 matches
Mail list logo