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 …
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 …
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 …
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 …
ubuntu - Determining PostgreSQL's port - Server Fault
I know that by default PostgreSQL listens on port 5432, but what is the command to actually determine PostgreSQL's port? Configuration: Ubuntu 9.10 with PostgreSQL 8.4
ubuntu - What default PostgreSql password? - Server Fault
May 28, 2019 · The default authentication mode for PostgreSQL is set to ident, not to sql DB user/password. Running cat /var/lib/pgsql/9.3/data/pg_hba.conf will show you that.
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 …
postgresql - Cannot connect to port 5432 locally even though it is ...
Dec 4, 2020 · I'm trying to setup my server so that port 5432 (Postgres) is accessible only from localhost. So I've denied everything, and added back port 5432, however I cannot connect to …
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 …
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 …