PostgreSQL?
Thanks for the attention.
Not an 'official' tool, but if you're familiar with OEM then EnterpriseDB does
PostgreSQL Enterprise Manager.
https://www.enterprisedb.com/products/edb-postgres-platform/edb-postgres-enterprise-managerpem
--
Martin Goodson
"Have y
On 15/06/2017 05:27, Andreas Kretschmer wrote:
Am 15.06.2017 um 01:18 schrieb Martin Goodson:
I'm just wondering how people may have implemented this. Do people
setup pgbouncer nodes on the database servers themselves, on
application servers, in the middle tier between the applicatio
On 14/06/2017 19:54, Rory Campbell-Lange wrote:
On 14/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
The new master's repmgr promote script will execute commands to pause
pgbouncer, reconfigure pgbouncer to point to the new database address, and
then resume.
You could just mov
screaming 'Why on earth is this
idiot not using X instead?' :)
Any input would be greatly appreciated.
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going
t I'm relatively
confident that should be OK, I was getting good results on my little
ubuntu box at home ...
Of course, I said the same think about compiling it :)
Huge thanks to EVERYONE who helped on this! If anyone is going to be at
PG Day UK, I'll buy you a drink :)
Regards
d Quadrant? Is this a 'bug' of some kind, or just a
really weird edge case? :)
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it.&quo
wxrwxrwx 1 root root 21 May 16 17:06 /lib64/libldap.so ->
libldap-2.4.so.2.10.3
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."
On 17/05/2017 16:15, Adrian Klaver wrote:
On 05/17/2017 07:26 AM, Martin Goodson wrote:
On 16/05/2017 18:46, Adrian Klaver wrote:
Per Tom's suggestion try
ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
Hello. Apologies for the delay in replying - medical appointment this
mo
On 16/05/2017 18:46, Adrian Klaver wrote:
Per Tom's suggestion try
ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
Hello. Apologies for the delay in replying - medical appointment this
morning :) Anyway, executed that command as suggested and this is the
output I got.
pginst@testd
On 16/05/2017 16:39, Martin Goodson wrote:
On 16/05/2017 15:58, Adrian Klaver wrote:
/bin/ld: warning: libssl.so.1.0.0, needed by
/db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with
libssl.so.10
/lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp'
collect2:
)
Many thanks for all the help so far. It's been very, very, helpful. I'm
sure it's nearly there ...
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?
On 16/05/2017 14:42, Adrian Klaver wrote:
On 05/16/2017 04:36 AM, Martin Goodson wrote:
On 15/05/2017 00:17, Martin Goodson wrote:
Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
Thank you so much, everybody, for your help! It's been invaluable!
Regard
On 15/05/2017 00:17, Martin Goodson wrote:
Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :)
Thank you so much, everybody, for your help! It's been invaluable!
Regards,
Martin.
*Sigh*. And things were going so well. With Adrian and Devrim's help I
/9.6.3/lib/postgresql'
/bin/mkdir -p '/opt/PostgreSQL/9.6.3/share/postgresql/contrib'
/usr/bin/install -c -m 755 repmgr_funcs.so
'/opt/PostgreSQL/9.6.3/lib/postgresql/repmgr_funcs.so'
/usr/bin/install -c -m 644 .//uninstall_repmgr_funcs.sql
repmgr_funcs.sql '/opt/Post
On 14/05/2017 19:26, Devrim Gündüz wrote:
Hi Martin,
On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote:
/usr/bin/ld: cannot find -lselinux
/usr/bin/ld: cannot find -lssl
/usr/bin/ld: cannot find -lcrypto
/usr/bin/ld: cannot find -lgssapi_krb5
/usr/bin/ld: cannot find -lz
collect2: error
On 12/05/2017 18:57, Adrian Klaver wrote:
On 05/12/2017 09:19 AM, Martin Goodson wrote:
On 12/05/2017 16:59, Adrian Klaver wrote:
Configuring Automatic failover using Replication Manager 2.0 on
PostgreSQL 9.3.5
http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html
on how easy it was and how much of an idiot I am, or my
abject failure and how much of an idiot I am :)
Many thanks!
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
On 12/05/2017 16:48, Adrian Klaver wrote:
On 05/12/2017 08:30 AM, Martin Goodson wrote:
On 12/05/2017 16:18, Joshua D. Drake wrote:
Thanks for the response. The problem is I'm kind of stuck with using
EnterpriseDB's community edition installers. It's a company policy. I
On 12/05/2017 16:18, Joshua D. Drake wrote:
On 05/12/2017 08:13 AM, Martin Goodson wrote:
Hello.
Yesterday I had problems getting repmgr installed, since our PostgreSQL
installs to a non-standard place, and doesn't use any postgresql
repositories/packages. The responses I got generally s
; failed
make: *** [repmgrd] Error 1
Any ideas what I am doing wrong? I can only assume I'm missing something
really, really, obvious. Every single book and article I've seen simply
states 'Just quickly install repmgr then ...' - it's driving me nuts
that I can't get this thing installed, let alone working :)
Any help/advice/suggestions/pointing-outs-of-the-obvious would be
greatly appreciated.
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."
res/9.6.2-3/bin
Is there a simple way to use repmgr from the package, perhaps by
copying/linking files from that location to ours? (e.g. copying/linking
some files from lib, bin, contrib, etc).
Or am I looking at having to compile the source? I'm told it should be
'simple'
21 matches
Mail list logo