network profile
|
Apr 30 |
comment |
PostgreSQL: Slave doesn't replicate the Master's data Could you check if you have recovery.conf ("/var/lib/postgresql/9.2/main/recovery.conf") and what's in it? |
|
Mar 22 |
comment |
PostgreSQL CREATE EXTENSION file not found error on Mac OS Probably, depending on the way you have installed Postgres, there's an extra "contrib" package you need to install |
|
Mar 22 |
comment |
Cannot `create function` in plpython3u, permission denied BTW the GRANT you're looking for is GRANT USAGE ON LANGUAGE plpython3u TO db_user. |
|
Feb 18 |
comment |
PostgreSQL can't start after tuning some options Have you followed the "Examine the log output." advice? Also you're trying to eliminate the symptoms most probably without looking for the root cause. |
|
Feb 18 |
comment |
Partition of tablespace How do you (intend to) backup - FS-level, SQL dump, any other way? |
|
Oct 4 |
awarded | Commentator |
|
Oct 4 |
comment |
Insert a 'null' string in a table in postgresql 'null' is completely different than NULL. And the "NOT NULL" constraint is related only to the latter. |
|
Aug 14 |
comment |
Starting PostgreSQL server after a HDD crash results in FAILED STATE And the Postgres' log? |
|
Jun 21 |
answered | How do I reset the postgres password for PostgreSQL on Windows? |
|
Apr 5 |
awarded | Editor |
|
Apr 5 |
revised |
How to connect to remote PostgreSQL server PostgreSQL and psql mentions fixed |
|
Apr 5 |
suggested | suggested edit on How to connect to remote PostgreSQL server |
|
Mar 11 |
answered | access columns returned by psql from bash |
|
Mar 9 |
awarded | Yearling |
|
Feb 2 |
comment |
PostgreSQL unexplained table bloat Updates also cause "bloat" - they are combination of delete and insert. |
|
Jan 28 |
answered | Postgresql: Move database to new tablespace |
|
Nov 7 |
awarded | Critic |
|
Nov 7 |
comment |
Postgres Server access restrict to only 1 database from list of databases A couple of corrections. a) "If you make changes to pg_hba.conf, you need to reload PostgreSQL"; b) Logging to Postgres always involves connecting to a database. You may later connect to a different database but you have to be connected to one at any given time. |
|
Oct 29 |
comment |
Delay after running pg_ctl reload I could think of only one reason - you have issued restart instead of reload, and then the DB waited for all existing clients to disconnect before shutting down and starting anew. |
|
Jul 21 |
comment |
psql denies access to file when using COPY FROM "Files named in a COPY command are read or written directly by the server, not by the client application. Therefore, they must reside on or be accessible to the database server machine, not the client. They must be accessible to and readable or writable by the PostgreSQL user (the user ID the server runs as), not the client. COPY naming a file is only allowed to database superusers, since it allows reading or writing any file that the server has privileges to access." (postgresql.org/docs/current/static/sql-copy.html) |
