The dumped file is just a plain-text file (Depending on the data types
within your database)
You should be able to open the backup you made with pg_dump in your
favourite editor such as vi and search through for the dodgy data. Clear out
the bad stuff, write it back to disk and you should be good
I have a backup done with "pg_dump" utility.
For some reason the backup file has 8 phisical bad sectors (17 KB of data)
Now when I try to restore the backup all tables are created successfully
and data of almost all tables restores successfully too, but one table
(the most important) appear em
On 10/20/07, yogesh <[EMAIL PROTECTED]> wrote:
> On Oct 19, 11:05 pm, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> > Yes, it's right. Triggers are part of a transaction (or run their
> > own) so if the trigger fails, so does the transaction.
> >
> > If you really need to have something insert rath
Hello Frnds,
I have to install the Postgres SQL on the Suse
LinuxGuide me with suitable steps to take..which version i
ave to use for postgres.
In wait of repliess from you..
Regards,
Yogesh Arora
---(end of broadcast)
On Oct 19, 11:05 pm, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> On 10/19/07, yogesh <[EMAIL PROTECTED]> wrote:
>
> > Hello frnds,
> > I have a trigger on a table with After UPDATE OR INSERT ..that insert
> > a record in an another table..If the Trigger Fire Correctly
> > the row is inser
On 10/19/07, Kevin Grittner <[EMAIL PROTECTED]> wrote:
>
> >>> On Fri, Oct 19, 2007 at 1:40 AM, in message
> <[EMAIL PROTECTED]>, "Mikko
> Partio"
> <[EMAIL PROTECTED]> wrote:
> >
> > I'm trying to figure out the minimum required to restore from a backup
>
> If you look inside that backup file, yo
