Hi,
Once I had the same problem with not existing schema. In my case removing
all the references to the schema worked fine and I had no problems with the
db ever since. It wa PG 8.2.1 and since the operation we migrated all the
DBs including the one to 9.0.6 and everything works fine.
Hope this
Hello,
after some fiddling i had success in making PostgreSQL 9.1 somewhat more
portable.
Some of our customers need to copy and run our application from an USB
device.
If the VC 2008 Redistributable packet is not installed PostgreSQL denies to
start.
Solution: copy msvcr90.dll + the manifest
Hello, everyone. I want to throw a scenario out there to see what y'all think.
Soon, my cluster backups will be increasing in size inordinately. They're going
to immediately go to 3x as large as they currently are with the potential to be
about 20x within a year or so.
My current setup uses
Hi Scott,
Why you do not replicate this master to the other location/s using other
methods like bucardo?, you can pick the tables you really want get
replicated there.
For the backup turn to hot backup (tar $PGDATA)+ archiving, easier,
faster and more efficient rather than a logical copy with
Both good points, thanks, although I suspect that a direct network copy of the
pg_data directory will be faster than a tar/untar event.
- Original Message -
Hi Scott,
Why you do not replicate this master to the other location/s using
other
methods like bucardo?, you can pick the
On Apr 25, 2012, at 10:11 AM, Scott Whitney wrote:
I believe, then, that when I restart server #3 (the standby who is
replicating), he'll say oh, geez, I was down, let me catch up on all that
crap that happened while I was out of the loop, he'll replay the WAL files
that were written while
On 04/25/2012 09:11 AM, Scott Whitney wrote:
...
My current setup uses a single PG 8.x...
My _new_ setup will instead be 2 PG 9.x ...
It is best to specify actual major version. While 8.0.x or 9.1.x is
sufficient to discuss features and capabilities, 9.1 is a different
major release than 9.0,
I mean bucardo (even though there are more tools like this one) just
for the replication stuff and the hot database backup only for the
backup stuff and only one bounce is needed to turn the archiving on, you
do not need to turn anything at all down during the backup.
A.A
On 04/25/2012
Hi folks,
Does anybody know if it is possible to create a PL which sends an http GET
request and retrieves its response ?
I am willing to use a REST service from within pgsql.
Maybe I am just trying to do an impossible.
Any hints ?
warm regards,
Ricardo
Ricardo Bayley ricardo.bay...@gmail.com wrote:
Does anybody know if it is possible to create a PL which sends an
http GET request and retrieves its response ?
Have you looked at PL/Python?
http://www.postgresql.org/docs/current/interactive/plpython.html
-Kevin
--
Sent via pgsql-admin
Hi all;
I've setup PostgreSQL to talk across servers thousand of times... not
sure what I'm doing wrong, maybe I'm just over-tired.
I have 2 scientific linux VM's running in vmware workstation
server 1 - 192.168.1.125
server 2 - 192.168.1.127
I've disabled selinux on both servers
Ive
Kevin Kempter cs_...@consistentstate.com writes:
I can scp files between the servers
Really?
$ psql -h 192.168.1.125
psql: could not connect to server: No route to host
Because that is not a Postgres problem, that is a network connectivity
problem. I'd bet that there's something wrong with
12 matches
Mail list logo
