How the Postgres database covering type recovery

Everybody is good, I now on the Postgres database backup and recovery has such a demand:

I set up a single access site in PC, the presence of Postgres database content. Every day I put the contents of the database using crontab backup to a file in ScholarWebsite.db.

At the same time, I set up the same web site on NB. I think PC backup ScholarWebsite.db content by means of recovery each week, into the mirror site in NB.

I use the NB command on the -U username -d database_name PSQL </dir/to/backup/ScholarWebsite.db .

But in this case, the terminal will prompt:
Error: constraint *** for relation ××× already exists.
Such information

In fact, in NB, a Schema already exists in the same database. My intention is, to update the way, on the PC website content updates to NB. Or, use the database backup files on PC direct overwrite the NB database file on line.

However, I have a superficial knowledge of the postgreSQL, and there are not too much energy on postgres. Would you have what is simple and direct a way? (I don't want to always put on the NB database empty, then use PC ScholarWebsite.db to NB recovery. )

Started by Monroe at June 15, 2016 - 11:44 AM

1)Direct overwrite file cover, needs to be covered by the POSTGRESQL service process stopped.
2)Use PG_MAN to do backup, as ORACLE RMAN, incremental recovery.
3)Using STANDBY mode, real-time replication.

Posted by Esther at June 29, 2016 - 12:29 PM

Nike's ads have long captured winning athletes and sports "heroes" as symbols of inspiration, tenacity,cheap nike shoes, and personal empowerment. Increasingly the message from the thoughttobe role models has been torpedoed by their behavior off camera; the consequence of bad behavior hasn't led to Nike dropping them from their marketing strategy. Think Kobe Bryant and Tiger Woods.
Nike's most recent bad boy is Pittsburgh Steelers quarterback Ben Roethlisberger who has been involved in two different sexual assault investigations in the last year . Earlier this week, Fred Bright, a Georgia District Attorney,nike air force ones, said Roethlisberger would not be prosecuted for rape because while significant questions persist about what happened,cheap nike sneakers, the evidence was insufficient to prove the case beyond a shadow of a doubt.
Related topics:


To stay in not have considered two ends that particular afre the wedding during the day have the identical target

Root of their plainness appeared to be of the fact

Really I not to favourable in regards to artwork56dB74e

Posted by Elton at July 03, 2016 - 12:46 PM