New answers tagged

0

If you were given CONNECT WITH GRANT OPTION you can then grant connect to others. If you were not given connect with grant option, you cannot grant it, you will need a superuser to grant you CONNECT GRANT OPTION, or to grant connect to the new user. A superuser (or database owner) would use this command to grant grant option for connect: GRANT CONNECT ON ...


0

I ended up here because my DB user saw only a few tables and not the newer ones. If this is your case, this has helped me. Grant privileges to all existing tables: GRANT SELECT ON ALL TABLES IN SCHEMA public TO user; Grant privileges to all new tables to be created in future (via default privileges): ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ...


0

After trying out different possible solutions (with some help), I found out that the postgres:11.14-bullseye works correctly and it contains all openssl hash functions. Interestingly, the default postgres:11 is missing them.


0

You might want to create and run the debug pod with the user it was originally planned for, otherwise you will receive permission denied while running commands inside the pod. This is the sequence of steps I executed: oc get -o yaml pod <postgresql-pod> | grep runAsUser runAsUser: 1000650000 oc scale deployment/<postgresql-d> --replicas=0 ...


1

If you set up Postgres replication by sending write-ahead log as described in streaming replication manual, then yes, all replicas are in the permanent recovery state which is normal. As write transactions are performed against the master node, the replicas receive and apply logs from the master, as any Postgres server in recovery would do. The changing ...


0

Copy on write does not give you integrity of the filesystem. Assuming that you meant filesystem journalling, which does give you filesystem integrity, then you should almost certainly still use Write Ahead Logging. Write Ahead Logging in PostgreSQL gives you database integrity at the transaction level, typically increases performance, as well as giving point ...


1

As mentioned in this link shared by @Mousumi , PgAudit is recommended. A recommended method for auditing in Cloud SQL for PostgreSQL is the pgAudit extension; see Auditing for PostgreSQL using pgAudit. Also, as mentioned here, for Cloud SQL and other supported products, Google will enter into a Business Associate Agreements(BAA) with customers as necessary ...


1

To answer the first question: Two types of audit logs are available for IAM: Admin Activity audit logs: Includes "admin write" operations that write metadata or configuration information. You can't disable Admin Activity audit logs. Data Access audit logs: Includes "admin read" operations that read metadata or configuration information. ...


0

I tried the approach above, and another issue I encountered was that the default Debian base that comes with the official Postgres Docker image doesn't have any other languages installed. # locale -a C C.UTF-8 en_US.utf8 POSIX To set another language, e.g. Chinese, it was necessary to run e.g. localedef -i zh_CN -c -f UTF-8 -A /usr/share/locale/locale.alias ...


2

local all all md5 local all postgres trust # ident Remember that the entries in pg_hba are processed in the order they given. "local all postgres trust" ... should allow me to log in ... without ... password And it would, if it appeared before the line that forced every local connection to use md5 authentication!


0

Clearly, postgres was not listening on the socket: Also the ls -l /var/run/postgresql/ gives the following: drwxr-s--- 2 postgres postgres 120 Ιούν 29 18:06 9.4-main.pg_stat_tmp -rw-r--r-- 1 postgres postgres 4 Ιούν 29 17:20 9.4-main.pid To enable the socket endpoint, configure unix_socket_directories in postgres conf (and make sure that the server is ...


0

For newer mediawiki versions, there are some pitfalls that breaks the mysql connection. Some attempts to fix are: Insert the port number on Database Host: $wgDBserver = "localhost:3306"; On some old LocalSettings.php, there are active configurations for PostgreSQL besides the Mysql config. Erase or comment it. # Postgres specific settings # $wgDBport ...


0

On Linux you would have PostgreSQL create a log with a simple name (such as postgresql.log) and then configure logrotate to manage the PostgreSQL log, rotating and deleting it as you require. Information to support this (though not telling you how to do this) is in the PostgreSQL docs section on log file maintenance. However, on Windows you (probably) won't ...


Top 50 recent answers are included