postgresql - What's the default superuser username/password for ...
Sep 21, 2017 · I have just installed postgres 8.4 on Ubuntu 9.10 and it has never asked me to create a superuser. Is there a default superuser and its password? If not, how do I create a new one?
Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?
The answers to your questions come from the online PostgreSQL 8.4 docs. GRANT ALL PRIVILEGES ON DATABASE grants the CREATE, CONNECT, and TEMPORARY privileges on a database to a …
postgresql - How do I give a postgres user all ... - Server Fault
Feb 19, 2023 · The service applications manage their own schema, so I want to give them admin-like privileges to their database, but they should not be able to touch anything else. Is there a way to set …
Stop PostgreSQL from starting on Windows? - Server Fault
Sep 15, 2011 · I have a local postgresql database for development purposes that I dont want to start up every time Windows does - how do I stop it from starting!
postgresql - Why can't user login on Postgres - Server Fault
When getting this error: psql: FATAL: password authentication failed for user "XXXX" despite the password being correct, the next thing to check is the validity of the account: SELECT usename, …
security - how to secure an open PostgreSQL port - Server Fault
Sep 9, 2014 · SSH tunnels aren't an option? This how-to article actually uses PostgreSQL as an example. You could provide the customer with a pre-configured SSH client to make it easy to connect.
GRANT SELECT to all tables in postgresql - Server Fault
Aug 30, 2009 · I thought it might be helpful to mention that, as of 9.0, postgres does have the syntax to grant privileges on all tables (as well as other objects) in a schema: GRANT SELECT ON ALL …
Why can't I grant select privileges to all table in schema with …
Dec 6, 2021 · ERROR: permission denied for table asm_info SQL state: 42501 Connect with user who is superuser or user with grantable privileges. Connect to the database in which table exists. [Most …
Setting up Postgres: Can't connect remotely to Postgres server
I am having a problem getting postgres to accept connections from my other server. Here's my setup: APP06 (10.55.129.31): Server running Postgres APP05 (10.55.129.30): Server trying to connect to
Postgres: How can I see all SQL statements being executed by the ...
Jun 4, 2009 · 26 I'm in the process of reviewing every SQL statement that an application makes against the database, for performance reasons. Is there an easy way to log all statements that are executed …