Daniel Vérité

1,777 reputation

213

bio	website	manitou-mail.org/about-dv.php
	location	Paris, France
	age
visits	member for	1 year, 3 months
	seen	1 hour ago
stats	profile views	35

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.

	1,777 reputation	bio	website	manitou-mail.org/about-dv.php	visits	member for	1 year, 3 months
213 badges		location	Paris, France		seen	1 hour ago

summary answers questions tags badges favorites bounties reputation activity

112 Actions

suggestions reviews revisions comments badges posts accepts all

1d	comment	How to set password for PostgreSQL database with a script? @ChocoDeveloper: in the case that you're thinking of a password assigned to the database itself, postgres doesn't have this. Passwords are assigned to database users which are separately granted the permission to connect to databases.
Jun 6	answered	pg_dump 9.2.x command does not work with pg_dump 9.2.3
Jun 5	answered	Postgresql constrains on FK
Jun 2	comment	postgres service suddenly not working after the computer crashed while working When the server quits immediately, it normally leaves some error messages in the server log, which is syslog or a file depending on the configuration. You need to consult this log.
May 31	answered	Postgres wont shutdown due to wal archiving
May 15	comment	Inconsistency in repeatable read Oops you're right @alice => comment deleted.
May 14	comment	What happen when Postgresql tablespace is null? Tablespaces are cluster-wide but `pg_tables` is only for the database you're connected to. Could you show all the databases with `select oid, datname, pg_database_size(datname) from pg_database` ?
May 3	comment	Can't connect to the postgres server ls: /tmp/.s.PGSQL.5432: No such file or directory The result of `ps` mentioned above actually indicates that postgres is not running, and it's confirmed by every other error you get. Look at the server log `/usr/local/var/postgres/server.log`. It probably tells what fatal error the server encountered that made it stop.
Apr 29	comment	PostgreSQL: Slave doesn't replicate the Master's data The trigger file shouldn't exist until the failover, that's its sole purpose. As for what the slave is doing, what's in the postgresql server log?
Apr 9	comment	Incremental backup in postgresql At 3MB/s, it would take ~15 hours to transfer the 160GB to the target system, which eliminates the cold backup option.
Apr 8	comment	Incremental backup in postgresql What's the transfer rate between your two servers?
Mar 27	awarded	Custodian
Mar 27	reviewed	No Action Needed Why is DROP DATABASE taking so long? (MySQL)
Mar 27	reviewed	No Action Needed In what data type should I store an email address in database?
Mar 26	answered	Postgres RIGHT JOIN with custom array
Mar 26	comment	How to turn the foreign key constraints on and off while db restore in postgres? Are you restoring into a non-empty database?
Mar 22	answered	postgres backup / restore: restored database much smaller?
Mar 22	comment	Cannot use python3 as stored procedure language in posgresql database @Stephane: `apt-cache search plpython`. `apt-cache show packagename` is useful as well.
Mar 22	answered	Cannot use python3 as stored procedure language in posgresql database
Mar 20	comment	clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server See what `pg_lsclusters` says, and `netstat -tln` for the addresses and ports that are listened to.