Hello All,
What strategies are people using for automated, script-based backup of
databases? There are a few I can think of:
1. Create a "db_backup" unix user and a "db_backup" pgsql user. Grant
READ access to all objects on all databases for the "db_backup" pgsql
user. Create a .pgpass
do the job using pg_dump/pg_dumpall, in case you need
the incremental backup you can opt for PITR WAL based archive logs...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/3/07, Joshua Kramer <[EMAIL PROTECTED]> wrote:
Hello All,
What strategies are people using for automated, s
If you really need three discrete instances, you might want to look at
using vmware to set up three separate virtual machines, each with their
own IPs etc... on that one box.
This was my thought; depending on how much RAM you have in each blade, you
could have two virtual servers on each blad
David,
I'm getting really mad at RHEL 4. They do not package a recent
postgres in the base distro, and only put 8.1.x in a disk call
lamp-beta... So now I wonder what a 'recommended' way of running
postgresql is -- meaning, any linux distro will do, just build it --
Why not just download the
d Bear wrote:
On Tue, Mar 20, 2007 at 09:06:35PM -0400, Joshua Kramer wrote:
David,
I'm getting really mad at RHEL 4. They do not package a recent
postgres in the base distro, and only put 8.1.x in a disk call
lamp-beta... So now I wonder what a 'recommended' way of running
Aaron,
You might want to probe a little further. Even though you know their
reason for wanting SQL Server - "cause it's what they know" - ask them
specifically what advantages SQL Server will give them over their current
setup. If you know what *they think* their objections are, then you ar
I already found that it's possible to store passwords in the file pgpass.conf
in the %APPDATA% directory. But that file isn't stored in that location. In
fact it doesn't exist in my disk. I already checked the "Store password"
Filipe,
You need to create that file yourself. Using the format
Also note that RedHat does PostgreSQL training:
https://www.redhat.com/training/developer/courses/rdb147.html
Note, however, that this is "RedHat Database" training. "RedHat Database"
was a rebranded PostgreSQL 7.3.4 introduced back around 2004; so I'm not
sure if this training would include
Hello Valter,
I am doing something similar with the Windows installer for the PostBooks
project. Basically, what I do is this:
1. Use the Postgres windows installer to install 8.2.7
2. Import all the application's databases.
3. Using the NSIS Installer Generation app:
1. Include all files u
