605 reputation
415
bio website francs3.blog.163.com
location China
age 30
visits member for 3 years, 2 months
seen 2 days ago

Translator of PostgreSQL 9 Admin Cookbook , PostgreSQL DBA

5 years working experience as a DBA,Good Knowledge on PostgreSQL, Oracle, MongoDB, Greenplumn and Linux.

Email: francs.tf@gmail.com

Blog: http://francs3.blog.163.com/

github: https://github.com/francs/


Jul
30
comment Replicate single table from Postgres 9.3 replica
I suggest use Londiste3 replicate a single table from primary db.
Jul
25
accepted Custom personal monitor sql by writing the .psqlrc file
Jul
25
comment Why is my composite index not used for this table?
How many data in your table ? and how many data you your sql get ?
Jul
25
comment Custom personal monitor sql by writing the .psqlrc file
@dezso : I test your advice , it works fine, thanks!
Jul
24
revised Custom personal monitor sql by writing the .psqlrc file
added 69 characters in body
Jul
24
asked Custom personal monitor sql by writing the .psqlrc file
Jul
8
awarded  Yearling
Jul
2
awarded  Curious
Jul
1
comment PostgreSQL partition pruning?
A very good answer.
Jun
16
comment In Postgresql, after pg_dump the access privileges on the database itself are not restored
try use a superuser instead when pg_dump.
Jun
3
comment What is the meaning of WAL file name?
@CraigRinger: thanks a lot!
Jun
3
accepted What is the meaning of WAL file name?
May
28
comment What is the meaning of WAL file name?
Does the wal composite of Timeline ID, Block ID, segment ID? I see this from the blog michael.otacoo.com/postgresql-2/…
May
28
comment What is the meaning of WAL file name?
Thanks for replying, I just want to know the exact meaning of wal filename.
May
28
revised What is the meaning of WAL file name?
added 4 characters in body
May
27
asked What is the meaning of WAL file name?
Apr
25
asked When enable authenticating in MongoDB, how to use mongo_fdw?
Apr
17
awarded  Popular Question
Apr
16
comment Unable to Start PostgreSQL. kernel's SHMMAX parameter exceeded you limit
A very good answer!
Apr
14
comment Why write ahead logs in PostgreSQL are generated every second
what's your archive_command say ?