Try not using batch and adding the DB host when prompted. Ensure you don’t have the name for the DB host in the /etc/hosts file pointing elsewhere.
Michelle Sullivan http://www.mhix.org/ Hallowed are those that walk in unison. > On 27 Aug 2021, at 09:32, Computerisms Corporation <[email protected]> > wrote: > > Maybe enable query logging on postgres? > > have you checked the bucardo logs for any details? pretty sure you can > enable debug level logging for that, as well. > >> On 2021-08-26 2:58 p.m., Thomas, Austin wrote: >> None as far as I can tell >> *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]* >> *From:* Computerisms Corporation <[email protected]> >> *Sent:* Thursday, August 26, 2021 3:00 PM >> *To:* Thomas, Austin <[email protected]>; Enrique P. >> <[email protected]> >> *Cc:* Michelle Sullivan <[email protected]>; [email protected] >> *Subject:* Re: [Bucardo-general] Bucardo Error >> And what about the postgres logs, any clues in there? >> On 2021-08-26 12:06 p.m., Thomas, Austin wrote: >> I have the same settings as you do with the exception of host. I >> didn’t use the –dbhost flag since specifying it will force >> PostgreSQL to use a network connection (even if ‘localhost’ is provided) >> *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:* Computerisms Corporation <[email protected]> >> <mailto:[email protected]> >> *Sent:* Thursday, August 26, 2021 12:34 PM >> *To:* Thomas, Austin <[email protected]> >> <mailto:[email protected]>; Enrique P. >> <[email protected]> <mailto:[email protected]> >> *Cc:* Michelle Sullivan <[email protected]> >> <mailto:[email protected]>; [email protected] >> <mailto:[email protected]> >> *Subject:* Re: [Bucardo-general] Bucardo Error >> Hi Austin, >> This is what my notes say I did to get it installed on my system. I >> remember having a bit of grief figuring out what commands to run as >> postgres, and what ones to run as bucardo, and I also remember that >> peer authentication in the pg_hba.conf didn't work, there is a >> previous post on this list from me that got an answer on the best >> way to set up the postgres permissions, might be worth chasing that >> down. There might also be more info in the postgres logs. >> su - postgres >> bucardo install >> *set: >> 1. Host: /var/run/postgresql >> 2. Port: 5432 <= note: check conf file >> 3. User: postgres >> 4. Database: postgres >> 5. PID directory: /var/run/bucardo >> On 2021-08-26 11:25 a.m., Thomas, Austin wrote: >> 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. >> 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]> >> -----Original Message----- >> From: Computerisms Corporation <[email protected]> >> <mailto:[email protected]> >> Sent: Wednesday, August 25, 2021 3:25 PM >> To: Thomas, Austin <[email protected]> >> <mailto:[email protected]>; Enrique P. >> <[email protected]> <mailto:[email protected]> >> Cc: Michelle Sullivan <[email protected]> >> <mailto:[email protected]>; [email protected] >> <mailto:[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] <mailto:[email protected]>>* >> > >> > *From:* Enrique P. <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] <mailto:[email protected]>>> >> > *Sent:* Wednesday, August 18, 2021 12:33 PM >> > *To:* Thomas, Austin <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] >> <mailto:[email protected]>>> >> > *Cc:* Michelle Sullivan <[email protected] >> <mailto:[email protected]> >> > <mailto:[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] >> <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] <mailto:[email protected]>> >> > >> > -----Original Message----- >> > >> > From: Michelle Sullivan <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] <mailto:[email protected]>>> >> > >> > Sent: Tuesday, August 17, 2021 7:50 PM >> > >> > To: Computerisms Corporation <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] <mailto:[email protected]>>> >> > >> > Cc: Thomas, Austin <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] >> <mailto:[email protected]>>>; [email protected] >> <mailto:[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/> >> <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]> >> > <mailto:[email protected] <mailto:[email protected]>>> >> > >> > >> *Sent:* Tuesday, August 17, 2021 7:28:06 PM >> > >> > >> *To:* Thomas, Austin <[email protected] >> <mailto:[email protected]> >> > <mailto:[email protected] >> <mailto:[email protected]>>>; >> > >> > >> [email protected] >> <mailto:[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]* >> <mailto:*[email protected]*>> >> > >> > >>> _______________________________________________ >> > >> > >>> Bucardo-general mailing list >> > >> > >>> [email protected] >> <mailto:[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>> >> > >> > >> <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] >> <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] https://bucardo.org/mailman/listinfo/bucardo-general
