3,710 reputation
419
bio website manitou-mail.org/about-dv.php
location Paris, France
age
visits member for 2 years, 4 months
seen 1 hour ago

Let's try to share the bits of knowledge gained during those innumerable hours of programming... Nowadays I use mostly PostgreSQL, C++/Qt, Perl, php on Unix servers.


Jul
18
answered PostgreSQL/ Linux, way to have DNS forward to a port/cluster?
Jul
17
comment Primary key with randomly varying increments (so it cannot be guessed easily)
What's the maximum acceptable size or format for the ID? The possible solutions depend mainly on that.
Jul
13
comment How to configure phpgdadmin?
Your web server lists the files instead of loading index.php. That's a php or web server config problem.
Jul
3
comment Selecting 3MB (or more/less) data from database server
What a strange question... select repeat('A',3000000) will give you 3 million bytes to fetch, if that's what you're after.
Jul
3
comment How many Maximum Number of database can be created in single instance of PostgreSQL?
Personally, I don't see what's unclear in this question, but anyway it appears to be a duplicate of: Maximum number of databases for single instance of PostgreSQL 9
Jun
26
comment Can I add a primary key automatically for all tables?
If a table doesn't have a PK, a person understanding the design should make a conscious decision about adding one or not. An artificial ID that would never going be used by any query is worthless and worse than that, a useless drag on write performance and a threat to previously-working code.
Jun
25
comment changed password for postgres login in pgAdmin, now can't connect to server
@jcollum: can you show the result of pg_lsclusters ?
Jun
25
answered changed password for postgres login in pgAdmin, now can't connect to server
Jun
25
comment Slow search times with functions despite index?
Given a have a few billion records with roughly 150 million a day: consider partitioning by day or even smaller time segments.
Jun
23
comment Issue working with Postgres on Windows
@a_horse_with_no_name: the asker doesn't get the option to use -f because the psql command line invocation is generated by pgadmin.
Jun
23
comment Issue working with Postgres on Windows
@George: your dump is apparently for MySQL, not PostgreSQL. It encloses table names between backticks like only MySQL does.
Jun
22
comment Problems while building plpgsql_check on Windows
It looks like you'd have to build it yourself from the source code.
Jun
20
comment Problems while building plpgsql_check on Windows
I don't know about the last part of the question, but anyway you don't link with a .DLL at build time, that's the root cause of the error. You want the corresponding .LIB instead. See for example stackoverflow.com/questions/24222423 but knowing that plpgsql.lib does not ship with entreprisedb pre-compiled binaries.
Jun
20
answered Issue working with Postgres on Windows
Jun
12
comment Postgres: my “data/backup” directory is way too large
@Reza: not necessarily, you may use streaming replication, without file-based log-shipping and archive_mode off on the master
Jun
12
answered Postgres: my “data/backup” directory is way too large
Jun
10
answered PgBouncer Uncertainties
Jun
9
answered trigger_file doesn't work
Jun
8
answered Column vs Field: have I been using these terms incorrectly?
Jun
8
comment trigger_file doesn't work
That would indicate the recovery.conf you're looking at is ignored by postgres. At least that's consistent with its trigger_file being ignored too.