Re: postgres service can't restart/start
Verify file permission is right, sometimes if you edit a conf file it changes owner and access permission En 4 de diciembre de 2019 18:55:38 Pepe TD Vo escribió: Hi experts, I am trying to install Postgresql 11.1 replication master-slave. The configure, make and make install went well. Initdb to the shared drive and psql are up and running. After configured pg_hba.conf and postgresql.conf, I can't restart the service and/or reload. Error is: ATHENTICATING for org.freedesktop.systemd1.manage-units --- Athentication is required to manage system services or units. authenticating as :user1 Password: -- ATHENTICATION COMPLETE -- Failed to start psotgres-11.service: unit no found. I worked around and add the postgres on pg_hba.conf and using pg_ctl to reload the service. Postgres server stopped but can't start, it complained about checkpoint_segments which I have set its to 8. Working with SA to reconfigure the authenticating and the server reaching out and getting authenticaion from org.freedesktop.systemd1.nanage-units. How can I by pass this issue and bring the postgres up? Bach-Nga No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more. To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly. *** Genuinely rich *** Faithful talent *** Sharing success
Re: login role password
Just: select * from pg_authid; En 4 de junio de 2019 15:14:49 Michael Shapiro escribió: PgAdmin3 has the ability to see the encrypted password for a login role. That allow me to copy the login role password from one server to another (without having to know the password). I don't see how to see the encrypted password for a login role in PgAdmin4
Re: cannot run pgadmin on database listening on port 5434
Looks like a firewall or pg_hba.conf issue, probably the 5433 is open to pgadmin4 client but not 5434. En 9 de enero de 2019 14:14:19 Mark Steben escribió: Good morning, I am running pgadmin4 (3.5) We currently run postgres 9.4.8 in our production environments I have a linux server running two instances of postgres 9.4. One listens on port 5433 and one listens on port 5434. I can login to the instance on 5433 but not on 5434, receiving this error: Unable to connect to server: could not connect to server: Connection timed out (0x274C/10060) Is the server running on host "10.93.156.52" and accepting TCP/IP connections on port 5434? As I mentioned databases are running and active on port 5433 AND 5434 on server 10.93.156.52. I can login to 5433 via pgadmin but not on 5434. Any comments/suggestions welcome. Thank you, -- Mark Steben Database Administrator @utoRevenue|Autobase CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com/DominionDealer www.drivedominion.com
Re: Does an Automation CLI or REST API exist?
Can this request be fulfilled talking directly to sqlite db in the back end? Cheers, Isaias S. En 3 de enero de 2019 6:28:17 Dave Page escribió: Hi On Thu, Jan 3, 2019 at 11:16 AM Alex Karasulu wrote: Hello, and happy new year to everyone, Just as the subject states I'm looking to automate the creation of server nodes in the UI. I want them to be made available as they're brought online in an environment automatically. Is there are REST or CLI based API for automating such operations? Please see https://www.pgadmin.org/docs/pgadmin4/3.x/export_import_servers.html Technically there is a REST API as that's how the UI talks to the backend, but it's not designed for public use, is undocumented, and may change significantly from release to release. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company