Search Postgresql Archives

How to recover my postgres database ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: How to recover my postgres database ?
From: Pierre Couderc <pierre@xxxxxxxxxx>
Date: Thu, 11 May 2017 18:53:23 +0200
Arc-authentication-results: i=1; mx.google.com; spf=pass (google.com: best guess record for domain of pgsql-general-owner+m230801=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-general-owner+M230801=spinic=gmail.com@xxxxxxxxxxxxxx
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:content-transfer-encoding :mime-version:user-agent:date:message-id:subject:from:to :arc-authentication-results; bh=Sg+NJTqaHAVQsGnTi39Z1L/lM1jl2Jty/qI1g0n9nCY=; b=MqzQDyjyjYp6jru4ePU3rEJM52GE749fV9ZSzem0ag3TwKJcdpaG5mp/FiI9nM8bTx iVBOaGhyX7lzEzGmQArMXF72qKOX3hfEeT8njY/pba3fqQuUfNsXiupndvBZJfwh+TCm nM3OcSwX4jUjcm9OJVfByxmyz7TKkiAmEdHQvu93hyyz/S2dNw1kgTgHb+WHhY4fYVZ9 81el1UnagI1dLt03fEAHhsiGFuDzGfTCb2CYdhe0ZKbDe+V4azrmuJHeb8zrRaAgxE4m kvvOU7M0ywPTDPrupbh0B3SroUt8lrrE03tEK/Ijs+ooi4Omifc8yoqxCJtMFy0I6NWK oKEg==
Arc-seal: i=1; a=rsa-sha256; t=1494521658; cv=none; d=google.com; s=arc-20160816; b=jrpq1QEnI/1amhrLHAvHUVZOfFZEA7wwqgVyE3xYIDuNpYiWXccIBDnj4AUWXIGjGz CqPwFhJEF2XBQ/ZCy7ZjxWcdR9QX9yOQeK64zFJnORXh9jR6ULT707LTtw98mLhXLn5h MnY7JxZaUivmX3M0PD4LopEo7gdfbBitH5XYkFIGii2qucoAtMUjBEhAThiH13diqmKd Qrt1jzj9PTPh7h/EQNmxSdYtlf/jMcfPsywMNGJxmjr8a91suLY98CaHerVd5tAdflvN H03yoo2OVsOitVLhINUqouQ5VaYOeAzExurlpdCBU1qX0FZBXepx2FQNtx8QQJe/1Zc0 YsRg==
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Icedove/45.6.0

I have broken my postgres database by typing :

psql <yyyy

instead of :

psql dbdb <yyyy

How can I safely repair, knowing that I have the pg_dumpall of lastnight, but many dbs have changed today... ?


Thanks in advance




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to recover my postgres database ?
  - From: John R Pierce
- Re: How to recover my postgres database ?
  - From: John R Pierce
- Re: How to recover my postgres database ?
  - From: Hunley, Douglas

Prev by Date: Re: Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?
Next by Date: Top posting....
Previous by thread: Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?
Next by thread: Re: How to recover my postgres database ?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]