Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgredac Dump

Postgredac Dump

From
"Bob Pawley"
Date:
Hi
 
Can anyone point me to an example of how to use the Postgresdac Dump component??
 
Bob

Re: Postgredac Dump

From
raghu ram
Date:


On Thu, May 12, 2011 at 10:02 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
Hi
 
Can anyone point me to an example of how to use the Postgresdac Dump component??
 


Below URL will give more detail information about Postgresdac dump::


--Raghu Ram
 

Re: Postgredac Dump

From
"Bob Pawley"
Date:
Hi Raghu
 
Thanks for the site.
 
I am still having problems.
 
The following downloads a file of 0 bytes.
 
  procedure TForm1.Button3Click(Sender: TObject);
begin
       PSQLDump1.DumpToFile('E5R', 'C:\PDW\E5R');
end;
 
(E5R is the database name.)
 
The Dump component points to a viable database.
 
I left the schema and tables empty as I understand that doing so will dump the whole database.
 
Any help would be appreciated.
 
Bob
 
From: raghu ram
Sent: Thursday, May 12, 2011 11:36 AM
Subject: Re: [GENERAL] Postgredac Dump
 


On Thu, May 12, 2011 at 10:02 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
Hi
 
Can anyone point me to an example of how to use the Postgresdac Dump component??
 
 
 
Below URL will give more detail information about Postgresdac dump::
 
 
--Raghu Ram
 
 

Re: Postgredac Dump

From
Raymond O'Donnell
Date:
On 13/05/2011 18:30, Bob Pawley wrote:
> Hi Raghu
> Thanks for the site.
> I am still having problems.
> The following downloads a file of 0 bytes.
> procedure TForm1.Button3Click(Sender: TObject);
> begin
> PSQLDump1.DumpToFile('E5R', 'C:\PDW\E5R');
> end;
> (E5R is the database name.)
> The Dump component points to a viable database.
> I left the schema and tables empty as I understand that doing so will
> dump the whole database.

Hi Bob,

I've only recently started using that component set, and haven't tried
the pg_dump one yet, so I'm only guessing, but it sounds as if something
is going wrong at the server end - maybe an authentication problem? What
does the PostgreSQL log say?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Re: Postgredac Dump

From
"Bob Pawley"
Date:
The last log entry was two hours before I attempted to dump.

Bob

-----Original Message-----
From: Raymond O'Donnell
Sent: Friday, May 13, 2011 10:44 AM
To: Bob Pawley
Cc: raghu ram ; Postgresql
Subject: Re: [GENERAL] Postgredac Dump

On 13/05/2011 18:30, Bob Pawley wrote:
> Hi Raghu
> Thanks for the site.
> I am still having problems.
> The following downloads a file of 0 bytes.
> procedure TForm1.Button3Click(Sender: TObject);
> begin
> PSQLDump1.DumpToFile('E5R', 'C:\PDW\E5R');
> end;
> (E5R is the database name.)
> The Dump component points to a viable database.
> I left the schema and tables empty as I understand that doing so will
> dump the whole database.

Hi Bob,

I've only recently started using that component set, and haven't tried
the pg_dump one yet, so I'm only guessing, but it sounds as if something
is going wrong at the server end - maybe an authentication problem? What
does the PostgreSQL log say?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Re: Postgredac Dump

From
"Bob Pawley"
Date:
Hi Ray

I finally got it to dump.

I switched the argument so that the path is first and the file name is after
the comma.

I found this hint on a very useful site that shows a number of examples of
PostgresDAC.

http://www.keashsoft.com/postgrestutorial/4.html

Bob

-----Original Message-----
From: Raymond O'Donnell
Sent: Friday, May 13, 2011 10:44 AM
To: Bob Pawley
Cc: raghu ram ; Postgresql
Subject: Re: [GENERAL] Postgredac Dump

On 13/05/2011 18:30, Bob Pawley wrote:
> Hi Raghu
> Thanks for the site.
> I am still having problems.
> The following downloads a file of 0 bytes.
> procedure TForm1.Button3Click(Sender: TObject);
> begin
> PSQLDump1.DumpToFile('E5R', 'C:\PDW\E5R');
> end;
> (E5R is the database name.)
> The Dump component points to a viable database.
> I left the schema and tables empty as I understand that doing so will
> dump the whole database.

Hi Bob,

I've only recently started using that component set, and haven't tried
the pg_dump one yet, so I'm only guessing, but it sounds as if something
is going wrong at the server end - maybe an authentication problem? What
does the PostgreSQL log say?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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