nerdexam
PostgreSQL_CE

PGCES-02 · Question #31

PostgreSQL CE PGCES-02 Exam I would like to restore the database cluster from the "db1.dump" backup file. Select the correct command from below. (Note: "postgres" is the superuser)

The correct answer is D. psql -U postgres -f db1.dump db1. See the full explanation below for the reasoning.

Question

PostgreSQL CE PGCES-02 Exam I would like to restore the database cluster from the "db1.dump" backup file. Select the correct command from below. (Note: "postgres" is the superuser)

Options

  • Apg_restore -U postgres -f db1.dump db1
  • Bpg_dump --restore db1 < db1.dump
  • Cpg_dump -U postgres --restore db1 < db1.dump
  • Dpsql -U postgres -f db1.dump db1
  • Epg_resetxlog -U postgres db1 < db1.dump

How the community answered

(46 responses)
  • A
    4% (2)
  • B
    2% (1)
  • C
    11% (5)
  • D
    80% (37)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice