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::

http://www.microolap.com/products/connectivity/postgresdac/help/TPSQLDump/Methods/DumpToFile.htm

--Raghu Ram

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
To: Bob Pawley
Cc: Postgresql
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::

http://www.microolap.com/products/connectivity/postgresdac/help/TPSQLDump/Methods/DumpToFile.htm

--Raghu Ram

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

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

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