Re: [ADMIN] Standalone Hot Backups

2013-08-21 Thread Christian Ullrich
* Sergey Arlashin wrote: In section 'Making a Base Backup Using the Low Level API' is said that once one has WAL archiving set up it is ok to omit pg_xlog folder from the backup dump: "You can, however, omit from the backup dump the files within the cluster's pg_xlog/ subdirectory. This slight

Re: [ADMIN] Standalone Hot Backups

2013-08-21 Thread Richard Poole
On Wed, Aug 21, 2013 at 09:35:23PM +0400, Sergey Arlashin wrote: > Hi! > I'm reading this article > http://www.postgresql.org/docs/current/static/continuous-archiving.htm > > In section 'Making a Base Backup Using the Low Level API' is said that once > one has WAL archiving set up it is ok to om

[ADMIN] Standalone Hot Backups

2013-08-21 Thread Sergey Arlashin
Hi! I'm reading this article http://www.postgresql.org/docs/current/static/continuous-archiving.htm In section 'Making a Base Backup Using the Low Level API' is said that once one has WAL archiving set up it is ok to omit pg_xlog folder from the backup dump: > "You can, however, omit from the b

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Jim C. Nasby
On Wed, Jun 07, 2006 at 09:25:18AM +0100, Andy Shellam wrote: > You would need to write your own installation script that would: > a) create the temporary data directory > b) install Postgres with all default options > c) modify the pg_hba.conf file to allow localhost trust access (ie. No > passwor

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Aaron Bono
You might check out Knoppix.  If your app will run on Linux you could create a full bootable Knoppix CD with everything installed - then they can play around all they want and just reboot to reset everything.  I am not sure if there is a Knoppix distro that can run within Windows. I do video demos.

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Scott Marlowe
On Wed, 2006-06-07 at 03:01, Andy Shellam wrote: > > Hello! > > > > Is it possible to have a CD with database and postgres binaries > > (win32), which can be directly run (without any installation) ? Or if it > > is impossible to be run from read-only media, to have it as > > self-extracting

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Andy Shellam
eforge.net.) Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Jarek > Sent: 07 June 2006 9:11 am > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Standalone Postgres > > Dnia 07-06-2006, sro o godzinie 0

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Jarek
Dnia 07-06-2006, śro o godzinie 09:01 +0100, Andy Shellam napisał(a): > You won't be able to run it all off CD no, as Postgres requires > log/transaction files etc to be written to. It also requires a service > user/data directory so it would have to be installed. OK. Let's assume, that I will ha

Re: [ADMIN] Standalone Postgres

2006-06-07 Thread Andy Shellam
yet) you might be better off looking at something like SQLlite, which uses flat-files. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Jarek > Sent: 07 June 2006 8:30 am > To: pgsql-admin@postgresql.org > Sub

[ADMIN] Standalone Postgres

2006-06-07 Thread Jarek
Hello! Is it possible to have a CD with database and postgres binaries (win32), which can be directly run (without any installation) ? Or if it is impossible to be run from read-only media, to have it as self-extracting archive, which can be run from any user account ? The goal is to have

Re: [ADMIN] standalone version of psql.exe?

2005-04-02 Thread Cris Carampa
Cris Carampa wrote: I'm wondering if there is a packaged standalone version of psql.exe for Windows, or if there is a way to extract only psql.exe and the required DLLs from a full PostgreSQL Windows installation and copy these files on another computer. I have to send some scripts to a client w

[ADMIN] standalone version of psql.exe?

2005-04-02 Thread Cris Carampa
I'm wondering if there is a packaged standalone version of psql.exe for Windows, or if there is a way to extract only psql.exe and the required DLLs from a full PostgreSQL Windows installation and copy these files on another computer. I have to send some scripts to a client which has a PostgreS

[ADMIN] STANDALONE

2001-07-10 Thread Sudheer Palapparambil
Hello, Can we run server and client on a single machine logged in as user postgres. Will it give any problems ? Sudheer ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl