Re: [GENERAL] BDR workers exiting?

2015-10-12 Thread Steve Pribyl
bdr. Glad to have a work around but would like to get to understand the failure. Steve Pribyl From: Steve Pribyl Sent: Monday, October 12, 2015 11:19 AM To: Andres Freund Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR workers exiting? Yup, th

Re: [GENERAL] BDR workers exiting?

2015-10-12 Thread Steve Pribyl
he change callback, associated LSN 2/FD250E48",,,,"bdr (6204748238611542317,1,16494,):receive" Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com Desk: 312-994-4646 From: Andres Freund Sent: Monday, October 12, 2015 11:08 AM To: Steve Prib

[GENERAL] BDR workers exiting?

2015-10-12 Thread Steve Pribyl
9:04.395 CDT,,,12693,,561bb1ae.3195,21,,2015-10-12 08:12:14 CDT,,0,LOG,0,"starting background worker process ""bdr (6204748238611542317,1,16494,)->bdr (6204748255428234532,1,""","" Steve Pribyl Thanks [ht

Re: [GENERAL] backup.old

2015-10-07 Thread Steve Pribyl
Thank you very much. I read someplace if you run pg_start_backup twice the backup.old will be created, but there was not much beyond that and now I can't seem to find the reference. Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com<mailto:steve.pri...@akunacapital.com>

Re: [GENERAL] backup.old

2015-10-07 Thread Steve Pribyl
Great, dur(rtfm), so is it save to delete the backup.old, if the db is not in backup mode. Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com<mailto:steve.pri...@akunacapital.com> Desk: 312-994-4646 From: David G. Johnston Sent: Wed

Re: [GENERAL] backup.old

2015-10-07 Thread Steve Pribyl
? Thanks Steve Pribyl From: pgsql-general-ow...@postgresql.org on behalf of Steve Pribyl Sent: Tuesday, October 6, 2015 10:47 PM To: John R Pierce; pgsql-general@postgresql.org Subject: Re: [GENERAL] backup.old Honestly I don't know. It was e

Re: [GENERAL] backup.old

2015-10-06 Thread Steve Pribyl
ackup BACKUP FROM: master START TIME: 2015-05-30 01:39:24 CDT LABEL: base-backup Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com Desk: 312-994-4646 From: pgsql-general-ow...@postgresql.org on behalf of John R Pierce Sent: Tuesday, Octo

[GENERAL] backup.old

2015-10-06 Thread Steve Pribyl
recover. postgresql-9.3 9.3.0-2.pgdg12.4+1 TIA Steve [http://www.akunacapital.com/images/akuna.png] Steve Pribyl | Senior Systems Engineer Akuna Capital LLC 36 S Wabash, Suite 310 Chicago IL 60603 USA | www.akunacapital.com <h

Re: [GENERAL] BDR Rejoin of failed node, hangs.

2015-10-06 Thread Steve Pribyl
That was it thanks. Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com Desk: 312-994-4646 From: Craig Ringer Sent: Tuesday, October 6, 2015 12:35 AM To: Steve Pribyl Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] BDR Rejoin of

Re: [GENERAL] BDR Rejoin of failed node, hangs.

2015-10-05 Thread Steve Pribyl
Good Morning, Has anyone had a moment to look at this? It is a bit of a show stopper. Thanks Steve From: pgsql-general-ow...@postgresql.org on behalf of Steve Pribyl Sent: Thursday, October 1, 2015 12:27 PM To: pgsql-general@postgresql.org Subject

[GENERAL] BDR Rejoin of failed node, hangs.

2015-10-01 Thread Steve Pribyl
postgresql-common 154 all PostgreSQL database-cluster manager TIA, Steve ________ [http://www.akunacapital.com/images/akuna.png] Steve Pribyl | Senior Systems Engineer Akuna Capital LLC 36 S Wabash, Suite 310 Chicago IL 606

Re: [GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
N postgres; GRANT ALL ON SCHEMA public TO postgres; COMMENT ON SCHEMA public Bad and happens to be the default: CREATE SCHEMA public AUTHORIZATION postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public; COMMENT ON SCHEMA public St

Re: [GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
ne)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-==---= ii postgresql-9.4 9.4.0-1.pgdg amd64object-relational SQL database, v St

Re: [GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
They all look like this. CREATE ROLE dbA NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; Steve Pribyl From: Adrian Klaver Sent: Tuesday, June 2, 2015 1:06 PM To: Steve Pribyl; Joshua D. Drake; pgsql-general@postgresql.org Subject: Re

Re: [GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
ture. Is this what is allowing write access to the database? Steve Pribyl Sr. Systems Engineer steve.pri...@akunacapital.com<mailto:steve.pri...@akunacapital.com> Desk: 312-994-4646 From: Melvin Davidson Sent: Tuesday, June 2, 2015 12:55 PM To: Steve Priby

Re: [GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
. Steve Pribyl From: pgsql-general-ow...@postgresql.org on behalf of Joshua D. Drake Sent: Tuesday, June 2, 2015 12:44 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres db permissions On 06/02/2015 10:36 AM, Steve Pribyl wrote: > >

[GENERAL] postgres db permissions

2015-06-02 Thread Steve Pribyl
Good Afternoon, Built a fresh 9.3. postgres server and added some users and noticed that any user can create tables in any database including the postgres database by default. Have I missed some step in securing the default install? Steve Pribyl [http

[GENERAL] Detecting master/slave

2014-11-21 Thread Steve Pribyl
/akuna.png] Steve Pribyl | Senior Systems Engineer Akuna Capital LLC 36 S Wabash, Suite 310 Chicago IL 60603 USA | www.akunacapital.com <http://www.akunacapital.com> p: +1 312 994 4646 | m: 847-343-2349 | f: +1 312 750 1667 | steve.pri...@akunacapital.com Please consider the environment,