Retried using `sudo su - postgres`, dropping the database via `psql -U postgres` and `DROP DATABASE bucardo;` `exit`, reinstalling Bucardo via `bucardo install --dbport=5432 --dbname=postgres --dbuser=postgres --batch`, and then try to setup the database via `bucardo add db db_postgresql-athomas-node1_lokidb` and I get the same error as before.
[cid:[email protected]] Best regards, Austin Thomas Senior Software Developer Mission Solutions – EGS SatOps Prototype and Integration (SPI) 6 N Tejon Street Suite 400 Colorado Springs, CO 80903 Office: 719.380.8488 Direct: 719.733.8100 Cell: 941.518.8488 [email protected] -----Original Message----- From: Computerisms Corporation <[email protected]> Sent: Wednesday, August 25, 2021 3:25 PM To: Thomas, Austin <[email protected]>; Enrique P. <[email protected]> Cc: Michelle Sullivan <[email protected]>; [email protected] Subject: Re: [Bucardo-general] Bucardo Error If you installed with sudo, then you installed as root. Bucardo, nor postgres, will be able to do anything to root-owned stuff. Try installing as the postgres user? On 2021-08-25 11:20 a.m., Thomas, Austin wrote: > Any update on this? I’m still stuck :/ > > *Best regards,* > > > > Austin Thomas > > *Senior Software Developer* > > *Mission Solutions – EGS SatOps Prototype and Integration (SPI) * > > *6 N Tejon Street Suite 400* > > *Colorado Springs, CO 80903* > > *Office: 719.380.8488* > > *Direct: 719.733.8100* > > *Cell: 941.518.8488* > > *[email protected]*<mailto:*[email protected]*> > > *From:* Thomas, Austin > *Sent:* Wednesday, August 18, 2021 1:11 PM > *To:* Enrique P. <[email protected]<mailto:[email protected]>> > *Cc:* Michelle Sullivan <[email protected]<mailto:[email protected]>>; > Computerisms Corporation > <[email protected]<mailto:[email protected]>>; > [email protected]<mailto:[email protected]> > *Subject:* RE: [Bucardo-general] Bucardo Error > > I’m able to use `psql -U postgres` and a `\c bucardo` to enter the > bucardo database. I’m able to run `\dt bucardo_config` and it appears > under the bucardo schema. > > Also maybe worth noting, I installed bucardo via `sudo bucardo install > –dbport=5432 –dbname=postgres –dbuser=postgres –batch` > > *Best regards,* > > > Austin Thomas > > *Senior Software Developer* > > *Mission Solutions – EGS SatOps Prototype and Integration (SPI) * > > *6 N Tejon Street Suite 400* > > *Colorado Springs, CO 80903* > > *Office: 719.380.8488* > > *Direct: 719.733.8100* > > *Cell: 941.518.8488* > > *[email protected]<mailto:*[email protected]> > <mailto:[email protected]>* > > *From:* Enrique P. <[email protected] > <mailto:[email protected]>> > *Sent:* Wednesday, August 18, 2021 12:33 PM > *To:* Thomas, Austin <[email protected] > <mailto:[email protected]>> > *Cc:* Michelle Sullivan <[email protected] > <mailto:[email protected]>>; Computerisms Corporation > <[email protected] > <mailto:[email protected]<mailto:[email protected]%20%3cmailto:[email protected]>>>; > [email protected]<mailto:[email protected]> > <mailto:[email protected]> > *Subject:* Re: [Bucardo-general] Bucardo Error > > Hi sir, > > Can you, using plain psql, access your bucardo database? And if so, is > the relation bucardo_config there? > > Best regards. > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > On Wednesday, August 18th, 2021 at 7:18 PM, Thomas, Austin > <[email protected] > <mailto:[email protected]<mailto:[email protected]%20%3cmailto:[email protected]>>> > wrote: > > I attempted the $(sudo -c ""command" bucardo) method with no luck > and I am using the postgres superuser for the bucardo. See sample > pg_hba.conf file below where master-n are my postgres IPs: > > Best regards, > > Austin Thomas > > Senior Software Developer > > Mission Solutions – EGS SatOps Prototype and Integration (SPI) > > 6 N Tejon Street Suite 400 > > Colorado Springs, CO 80903 > > Office: 719.380.8488 > > Direct: 719.733.8100 > > Cell: 941.518.8488 > > [email protected]<mailto:[email protected]> > <mailto:[email protected]> > > -----Original Message----- > > From: Michelle Sullivan <[email protected] > <mailto:[email protected]>> > > Sent: Tuesday, August 17, 2021 7:50 PM > > To: Computerisms Corporation <[email protected] > <mailto:[email protected]>> > > Cc: Thomas, Austin <[email protected] > <mailto:[email protected]>>; > [email protected]<mailto:[email protected]> > <mailto:[email protected]> > > Subject: Re: [Bucardo-general] Bucardo Error > > You’re using the sudo command to root... I assume your Postgres > instance has a root user or you have setup your .rc file with > credentials.. however, don’t forget that if you chose a user other > than the default “bucardo” you *will* need to setup credentials in > the Shell home directory for the root user.. if you used the > defaults you may still need to depending on the version and who you > were when you used the bucardo setup utility. > > Michelle Sullivan > > http://www.mhix.org/ <http://www.mhix.org/> > > Hallowed are those that walk in unison. > > > On 18 Aug 2021, at 11:40, Computerisms Corporation > <[email protected] > <mailto:[email protected]<mailto:[email protected]%20%3cmailto:[email protected]>>> > wrote: > > > > > > well, guess that isn't the problem then ;) > > > > > > I note you are using sudo to run the command. Not sure how your > setup works, but on my systems I need to have a bucardo users, and > do $(sudo -c "commands go here" bucardo), or switch to the bucardo user. > > > > > >> On 2021-08-17 6:35 p.m., Thomas, Austin wrote: > > >> I've only started the bucardo installation on one instance so far. > > >> I've been testing and installing on node-1 Get Outlook for iOS > > >> <https://aka.ms/o0ukef > <https://aka.ms/o0ukef<https://aka.ms/o0ukef%20%3chttps:/aka.ms/o0ukef>>> > > >> > > --------------------------------------------------------------------- > > >> --- > > >> *From:* Computerisms Corporation <[email protected] > <mailto:[email protected]>> > > >> *Sent:* Tuesday, August 17, 2021 7:28:06 PM > > >> *To:* Thomas, Austin <[email protected] > <mailto:[email protected]>>; > > >> [email protected]<mailto:[email protected]> > <mailto:[email protected]> > <[email protected] > <mailto:[email protected]<mailto:[email protected]%20%3cmailto:[email protected]>>> > > >> *Subject:* Re: [Bucardo-general] Bucardo Error just a guess; > perhaps > > >> you are running the command on the postgres instance that is > *not > > >> running bucardo? > > >>> On 2021-08-17 2:51 p.m., Thomas, Austin wrote: > > >>> Anyone seen this error before with Bucardo? Google says to > make > > >>> sure the Bucardo database and postgres user are created but > I've > > >>> already confirmed that… *Best regards,* Austin Thomas *Senior > > >>> Software Developer* *Mission Solutions – EGS SatOps Prototype > and > > >>> Integration (SPI) * > > >>> *6 N Tejon Street Suite 400* > > >>> *Colorado Springs, CO 80903* > > >>> *Office: 719.380.8488* > > >>> *Direct: 719.733.8100* > > >>> *Cell: 941.518.8488* > > >>> *[email protected]*<mailto:*[email protected]*> > <mailto:*[email protected]*> > > >>> _______________________________________________ > > >>> Bucardo-general mailing list > > >>> [email protected]<mailto:[email protected]> > <mailto:[email protected]> > > >>> https://bucardo.org/mailman/listinfo/bucardo-general > <https://bucardo.org/mailman/listinfo/bucardo-general> > > >> <https://bucardo.org/mailman/listinfo/bucardo-general > <https://bucardo.org/mailman/listinfo/bucardo-general>> > > > _______________________________________________ > > > Bucardo-general mailing list > > > [email protected]<mailto:[email protected]> > <mailto:[email protected]> > > > https://bucardo.org/mailman/listinfo/bucardo-general > <https://bucardo.org/mailman/listinfo/bucardo-general> >
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
