Rich:
On Tue, Mar 14, 2017 at 11:42 PM, Rich Shepard wrote:
> 2.) I'm far from being a professional DBA but if I had to back up a 13T
> database what I'd do (since I use only linux) is run pg_dump with the
> archive (tar) format, then use dirvish to synchronize it with a remote copy.
> Dirvish
On 15 March 2017 at 03:04, John McKown wrote:
> Your message is not diplaying. At least not for me. I guess that my reader
> does not understand the "smime.p7m" file, which shows as an attachment. For
> others, his question is:
>
> === original question from Lawrence Cohan ===
>
> Yes, this is wh
Attention:
The information contained in this message and or attachments is intended only
for the person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of, or tak
Attention:
The information contained in this message and or attachments is intended only
for the person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of, or tak
On Tue, 14 Mar 2017, Adrian Klaver wrote:
What would be a recommended solution for backing up a very large Postgres
(~13TeraBytes) database in order to prevent from data deletion/corruption.
Current setup is only to backup/restore to a standby read-only Postgres
server via AWS S3 using wal-e how
On 03/14/2017 01:58 PM, Lawrence Cohan wrote:
Cut-and-paste from winmail.dat:
"Let's try this one more time in plain text and please note that I'm
creating the email totally in plain text, and send as plain text.
Unfortunately I have no control on the mail server if that's where this
message
Lawrence,
First off, I strongly recommend that you figure out how to send regular
plain-text emails, at least to this mailing list, as the whole
"winmail.dat" thing is going to throw people off and you're unlikely to
get many responses because of it.
Regarding your question..
* Lawrence Cohan (l
gt; pgsql-general@postgresql.org>
> Cc:
> Bcc:
> Date: Tue, 14 Mar 2017 15:57:39 -0400
> Subject: RE: [GENERAL] Postgres backup solution
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.
Attention:
The information contained in this message and or attachments is intended only
for the person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of, or tak
On 3/14/2017 12:31 PM, Lawrence Cohan wrote:
Subject:
Postgres backup solution
From:
Lawrence Cohan
Date:
3/14/2017 12:31 PM
To:
"pgsql-general@postgresql.org"
was there supposed to be a question or statement or something here ?
--
john r pierce, recycling bits in santa cruz
Attention:
The information contained in this message and or attachments is intended only
for the person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or other
use of, or tak
On Tue, May 12, 2009 at 05:25:26PM +0530, CM J wrote:
> The above results in following exception and the data is not getting
> restored:
>
> ERROR: duplicate key violates unique constraint
> "pg_largeobject_loid_pn_index"
>
> What else do i need to drop/delete to completely reinitial
Hi,
I backup my database using the following command:
pg_dump.exe -f Backup.sql -U -p MYDB
Now,before restoring, i drop all my tables,indexes,foreign key
constraints.Then, i restore using the cmd below:
psql.exe -U -p -d MYDB -f Backup.sql
The above results in following
On 10/3/06, Martijn van Oosterhout wrote:
On Sun, Oct 01, 2006 at 09:20:12PM -0700, pd wrote:
> guys,
>
> i have a java web app with a postgres backend. now i want to implement
> a db database functionality from within my web app. now i have got
> this so far,
>
> String[] args = {"\"C:\\Program
On Sun, Oct 01, 2006 at 09:20:12PM -0700, pd wrote:
> guys,
>
> i have a java web app with a postgres backend. now i want to implement
> a db database functionality from within my web app. now i have got
> this so far,
>
> String[] args = {"\"C:\\Program
> Files\\PostgreSQL\\8.1\\bin\\pg_dump\"",
guys,
i have a java web app with a postgres backend. now i want to implement
a db database functionality from within my web app. now i have got
this so far,
String[] args = {"\"C:\\Program
Files\\PostgreSQL\\8.1\\bin\\pg_dump\"", " -i", " -h", " localhost", "
-p", " 5432", " -U", " postgres", " -
16 matches
Mail list logo
