Re: [GENERAL] Database backup to network folder

2011-08-01 Thread Craig Ringer
On 1/08/2011 1:35 PM, kalyan kumar wrote: Hi, I am using Postgre SQL 8.3, where I want to backup my entire database. For the same I am using pg_dump.exe. I am able to take the backup of my database in to my local machine. If I want to take the backup into network folder, how to pass "-f" paramet

Re: [GENERAL] Database backup to network folder

2011-08-01 Thread Raymond O'Donnell
On 01/08/2011 06:35, kalyan kumar wrote: > Hi, > > I am using Postgre SQL 8.3, where I want to backup my entire database. > For the same I am using pg_dump.exe. I am able to take the backup of my > database in to my local machine. If I want to take the backup into > network folder, how to pass "-f

[GENERAL] Database backup to network folder

2011-07-31 Thread kalyan kumar
Hi, I am using Postgre SQL 8.3, where I want to backup my entire database. For the same I am using pg_dump.exe. I am able to take the backup of my database in to my local machine. If I want to take the backup into network folder, how to pass "-f" parameter to pg_dump.exe. I am using SMB to impl

Re: [GENERAL] database backup throws errors

2011-04-07 Thread Tom Lane
"Michael Molz" writes: > we´re running PostgreSQL 8.4.7 for an CRM System on a Linux machine. > Database contains about 540 tables with summary about 2.5 million records. > Since this weeks the backup stops with an error message always at the same > table. It´s irrelevant what tool we use to

[GENERAL] database backup throws errors

2011-04-07 Thread Michael Molz
Hi folks, we´re running PostgreSQL 8.4.7 for an CRM System on a Linux machine. Database contains about 540 tables with summary about 2.5 million records. Since this weeks the backup stops with an error message always at the same table. It´s irrelevant what tool we use to backup (pgAdmin III,

Re: [GENERAL] database backup trouble

2007-02-05 Thread Tomi N/A
2007/2/3, George Weaver <[EMAIL PROTECTED]>: >it's a windows-related problem Is the Task Scheduler service running? (Start > Settings > Control Panel > Administrative Tools > Services - Task Scheduler?). If the Task Scheduler service is running , what does the Task Scheduler log indicate abou

Re: [GENERAL] database backup trouble

2007-02-03 Thread George Weaver
From: "Tomi N/A" And the .bat file script? The .bat script is of no importance: So be it... it's a windows-related problem Is the Task Scheduler service running? (Start > Settings > Control Panel > Administrative Tools > Services - Task Scheduler?). If the Task Scheduler service is r

Re: [GENERAL] database backup trouble

2007-02-02 Thread Tomi N/A
2007/2/2, George Weaver <[EMAIL PROTECTED]>: And the .bat file script? The .bat script is of no importance: it's a windows-related problem (or, to be more precise, the problem of my ignorance when it comes to windows scripting). The most trivial .bat scripts containing only a simple echo state

Re: [GENERAL] database backup trouble

2007-02-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/02/07 06:01, Tomi N/A wrote: > I'm trying to set up an automatic backup mechanism and have a number > of questions about issues I've encountered. > First of all, I tried to install pgAgent (the server is running win2k3 > and pgsql 8.1.5). Trying

Re: [GENERAL] database backup trouble

2007-02-02 Thread George Weaver
From: "Tomi N/A" > At this point, I decided to try a much more primitive approach: using > a windows scheduled task running a .bat or .cmd script which in turn > calls pg_dump. It might be helpful if you provided the exact pg_dump command you are trying to use, as well as the text of the .ba

Re: [GENERAL] database backup trouble

2007-02-02 Thread Richard Huxton
Tomi N/A wrote: 2007/2/2, George Weaver <[EMAIL PROTECTED]>: From: "Tomi N/A" > At this point, I decided to try a much more primitive approach: using > a windows scheduled task running a .bat or .cmd script which in turn > calls pg_dump. It might be helpful if you provided the exact pg_dump c

Re: [GENERAL] database backup trouble

2007-02-02 Thread Tomi N/A
2007/2/2, George Weaver <[EMAIL PROTECTED]>: From: "Tomi N/A" > At this point, I decided to try a much more primitive approach: using > a windows scheduled task running a .bat or .cmd script which in turn > calls pg_dump. It might be helpful if you provided the exact pg_dump command you are tr

Re: [GENERAL] database backup trouble

2007-02-02 Thread George Weaver
From: "Tomi N/A" At this point, I decided to try a much more primitive approach: using a windows scheduled task running a .bat or .cmd script which in turn calls pg_dump. It might be helpful if you provided the exact pg_dump command you are trying to use, as well as the text of the .bat file

[GENERAL] database backup trouble

2007-02-02 Thread Tomi N/A
I'm trying to set up an automatic backup mechanism and have a number of questions about issues I've encountered. First of all, I tried to install pgAgent (the server is running win2k3 and pgsql 8.1.5). Trying to start the pgagent service results in an "error 193", one google knows very little abou

[GENERAL] database backup...

2001-02-22 Thread Jinsoo Hwang
Hi, Our old(7.0.2) postgres base directory is, say /user3/local/pgsql and new(7.0.3) postgres base directory is /usr/local/pgsql. As the doc suggested I tried to backup the whole data(7.0.2), but it was unsuccessful. Since the normal restoration is almost over, I was thinking about the other po