pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase Backup
5+ messages / 4 participants
[nested] [flat]
* Database Backup
@ 2004-10-06 02:39 sreejith s <getsreejith@gmail.com>
2004-10-06 15:19 ` Re: Database Backup sklassen@commandprompt.com
0 siblings, 1 reply; 5+ messages in thread
From: sreejith s @ 2004-10-06 02:39 UTC (permalink / raw)
To: pgsql-sql
Hello,
Now i am working on Linux database server/Windows Client project.
I have a doubbt. How to take DB backup from my windows client machine
where DB is intsalled at linux server. pg_dump doen't works from
windows client butr its working from local server machine. How to
rectify the problem. Then ho w to call pl/pgsql function from VB/.NET.
Sreejith
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database Backup
2004-10-06 02:39 Database Backup sreejith s <getsreejith@gmail.com>
@ 2004-10-06 15:19 ` sklassen@commandprompt.com
0 siblings, 0 replies; 5+ messages in thread
From: sklassen@commandprompt.com @ 2004-10-06 15:19 UTC (permalink / raw)
To: sreejith s <getsreejith@gmail.com>; +Cc: pgsql-sql
* sreejith s <getsreejith@gmail.com> [2004-10-06 08:09:38 +0530]:
> Now i am working on Linux database server/Windows Client project. I
> have a doubbt. How to take DB backup from my windows client machine
> where DB is intsalled at linux server. pg_dump doen't works from
> windows client butr its working from local server machine. How to
> rectify the problem.
What errors are you getting?
> Then ho w to call pl/pgsql function from VB/.NET.
I don't know if there's some VB/.NET specific voodoo, but the
following should work:
SELECT foo() AS result;
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
^ permalink raw reply [nested|flat] 5+ messages in thread
* Database backup
@ 2004-10-17 03:19 sreejith s <getsreejith@gmail.com>
2004-10-17 03:34 ` Re: Database backup Steven Klassen <sklassen@commandprompt.com>
2004-10-18 16:39 ` Re: Database backup Andreas <maps.on@gmx.net>
0 siblings, 2 replies; 5+ messages in thread
From: sreejith s @ 2004-10-17 03:19 UTC (permalink / raw)
To: pgsql-sql
Hai,
How to take Database backup from an application developed in Visual
Basic thats running at Windows Client and Database resting at Linux
Server. THanx
Sreejith
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database backup
2004-10-17 03:19 Database backup sreejith s <getsreejith@gmail.com>
@ 2004-10-17 03:34 ` Steven Klassen <sklassen@commandprompt.com>
1 sibling, 0 replies; 5+ messages in thread
From: Steven Klassen @ 2004-10-17 03:34 UTC (permalink / raw)
To: sreejith s <getsreejith@gmail.com>; +Cc: pgsql-sql
* sreejith s <getsreejith@gmail.com> [2004-10-17 08:49:44 +0530]:
> How to take Database backup from an application developed in Visual
> Basic thats running at Windows Client and Database resting at Linux
> Server. THanx
pg_dump -U your_username your_database > your_database.sql
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database backup
2004-10-17 03:19 Database backup sreejith s <getsreejith@gmail.com>
@ 2004-10-18 16:39 ` Andreas <maps.on@gmx.net>
1 sibling, 0 replies; 5+ messages in thread
From: Andreas @ 2004-10-18 16:39 UTC (permalink / raw)
To: sreejith s <getsreejith@gmail.com>; +Cc: pgsql-sql
sreejith s wrote:
>How to take Database backup from an application developed in Visual
>Basic thats running at Windows Client and Database resting at Linux
>Server. THanx
>
>
You wrote a similar question some days ago and mentioned that pg_dump
wouldn't work on Windows, so I figure you don't want to let the Linux
host computer make the backups but your Windows client.
You could go 2 ways.
1)
Install pg_dump on your Windows client.
Either as PostgreSQL on a CygWin environment or a Windows-native
PostgreSQL 7.5 or 8.0 installation.
Since you only need pg_dump you wouldn't configure a running PostgreSQL
so this should be pretty easy.
E.g. the Linux host's IP is 192.168.0.123. Then you can run on Windows :
pg_dump --host=192.168.0.123 -U your_username your_database >
your_database.sql
2)
Let the Linux server do the backup and transfer the resulting backup
file as soon as possible to your Windows client.
a) The server could push it through SAMBA, SCP or FTP.
b) The client could collect all backup files when it gets booted, if
the server puts the files in a SAMBA share that the client can mount as
network drive or access via FTP.
I'd propose you take the alternative 2) b).
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-10-18 16:39 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-06 02:39 Database Backup sreejith s <getsreejith@gmail.com>
2004-10-06 15:19 ` sklassen@commandprompt.com
2004-10-17 03:19 Database backup sreejith s <getsreejith@gmail.com>
2004-10-17 03:34 ` Re: Database backup Steven Klassen <sklassen@commandprompt.com>
2004-10-18 16:39 ` Re: Database backup Andreas <maps.on@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox