Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql
Search options not deleted
user 1923
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
26
votes
2
answers
68k
views
PgAdmin III - How to connect to database when password is empty?
I have installed PostgreSQL 9.1 on my PC (Win 7). I have a small Java application connecting successfully to it with login=sa and password="". The connection works. …
- 1,481
4
votes
1
answer
4k
views
Could not open file "pg_clog/0000": No such file or directory
My local PostgreSql 9.2 database won't start anymore this morning. I am on Windows 7. Yesterday, I performed a Windows Update before going to bed. … Should I reinstall PostgreSql 9.2? Is there a command to restore it in a proper state? …
- 1,481
4
votes
2
answers
3k
views
Should I create an index for non key columns?
I have a table in a PostGreSql database defined as following:
CREATE TABLE public." …
- 1,481
3
votes
1
answer
12k
views
How to generate time in milliseconds in PostgreSQL stored procedure?
I have been reading the Postgres documentation about timestamps, but I am still a little bit confused.
I need to store moments in times, measured in milliseconds, between the current time and midnigh …
- 1,481
2
votes
1
answer
644
views
How to perform asynchronous cascade slave replication of PostgreSQL database?
Let's imagine a PostgreSQL database running online (like those from Heroku for example). … Is this possible from a PostgreSQL perspective? If yes, what would be the best Postgres implementation/configuration strategy? What do I need to learn? …
- 1,481
1
vote
1
answer
2k
views
Explain PostgreSql ssl_cipher values: ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH
In the postgresql.conf file, one can configure authorized values for ssl_cipher. Yet I could not find documentation explaining what the ALL, ADH, LOW, EXP, MD5 and STRENGTH values correspond to.
MD5 …
- 1,481
0
votes
1
answer
275
views
Is there a benefit to using FOR SHARE in this PostgreSql simple select?
In the following PgSql stored function:
CREATE OR REPLACE FUNCTION get_offer_from_id(
offer_id bigint)
RETURNS json AS $$
DECLARE
res "entity_data_result";
r "get_offer_data";
B …
- 1,481
0
votes
1
answer
2k
views
How to update array fields in a table in Postgresql?
next_a1;
tmp_a2 := r.a2 || next_a2;
UPDATE my_tbl SET ( "a1", "a2" ) = ( tmp_a1, tmp_a2 )
WHERE "id" = iid;
END LOOP;
END; $$
LANGUAGE plpgsql;
I am on Postgresql …
- 1,481