Notices tagged with postgres
-
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Monday, 26-Jul-2021 14:06:03 UTC Douglas A. Whitfield #postgres dump schemas by default, right? What would be a reason why it wouldn't do that? -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Thursday, 29-Apr-2021 14:11:08 UTC Douglas A. Whitfield Are the issues presented in https://citusdata.com/blog/2015/09/09/pgshard-learn-from-failure/ regarding failover still relevant in 2021? #postgres #pgsql #postgresql -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Monday, 19-Apr-2021 19:28:07 UTC Douglas A. Whitfield What versions of #postgres have table limitations, if any? Running into issues with #pg_dump. #postgresql In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Monday, 08-Feb-2021 22:37:10 UTC Douglas A. Whitfield #postgres folks, any out-of-the-box thoughts about this error:
psql: error: could not connect to server: could not connect to server: Connection refused
Is the server running on host "10.14.202.76" and accepting
TCP/IP connections on port 9999?
Obviously, the firewall has been checked.In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 02-Jun-2020 21:52:40 UTC Douglas A. Whitfield this is owned by the proper user: [centos@ip-10-250-75-75 16:44:13 wildfly-19.0.0.Final]$ ls -la /opt/wildfly-19.0.0.Final/modules/com/mysql/main/mysql-connector-java.jar
-rw-r--r-- 1 wildfly wildfly 883898 Jun 2 16:21 /opt/wildfly-19.0.0.Final/modules/com/mysql/main/mysql-connector-java.jar
But it doesn't show up as a JDBC driver in the #wildfly #HAL.
I did use a different process that for #postgres, but I didn't think I need to install via webui to get it to show up in webui.In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Thursday, 28-May-2020 18:21:10 UTC Douglas A. Whitfield so, my #postgres application seems to work in #wildfly. I guess I need to write a #java application to test it? I've never used Wildfly before so...yeah. In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 13-May-2020 13:25:37 UTC Douglas A. Whitfield It has been a while since I have done anything with #MySQL and #Postgres. I keep forgetting that the package 'mysql' is not the server.
Of course, the Zabbix instructions could be a lot better in this regard. !monitoringIn conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Monday, 27-Apr-2020 20:14:53 UTC Douglas A. Whitfield To flesh that out a bit, but my current list is this:
#mongodb
#mysql
#httpd
#postgres
#kafka
#cassandra
#tomcat
#jboss / #wildfly
#eclipse
#java (enough to diagnose applications...honestly, with the others on the list that are built in java, I probably don't really need to do anything else with this one)In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Monday, 17-Apr-2017 17:11:25 UTC Douglas A. Whitfield I have zero experience with stored procedures. How would I tell if there are any for #Postgres and #MySQL? In conversation from nu.federati.net permalink -
Douglas A. Whitfield (musicman@nu.federati.net)'s status on Tuesday, 11-Apr-2017 20:41:23 UTC Douglas A. Whitfield journalctl -xe not really telling me much. I know much more about mysql than #postgres. Any help appreciated.
[root@server]# systemctl status postgresql.service
â postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2017-04-11 12:33:32 CDT; 41s ago
Process: 4464 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)
Apr 11 12:33:32 nagiosxi.mouser.lan systemd[1]: Starting PostgreSQL database server...
Apr 11 12:33:32 nagiosxi.mouser.lan systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 11 12:33:32 nagiosxi.mouser.lan systemd[1]: Failed to start PostgreSQL database server.
Apr 11 12:33:32 nagiosxi.mouser.lan systemd[1]: Unit postgresql.service entered failed state.
Apr 11 12:33:32 nagiosxi.mouser.lan systemd[1]: postgresql.service failed.In conversation from nu.federati.net permalink -
MMN-o ✅⃠ (mmn@social.umeahackerspace.se)'s status on Tuesday, 15-Mar-2016 13:12:38 UTC MMN-o ✅⃠ @maiyannah @moonman Because #MySQL (and #MariaDB) sucks and the only reason people still use it is because of legacy? :)
#Postgres beats the crap out of it any day.In conversation from social.umeahackerspace.se permalink