I have been struggling to install slony 2.0 for past few days.
Linux server detail : Linux vmbndbdev01 2.6.32-279.el6.x86_64 #1 SMP Fri Jun
22 12:19:21 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
I have 2 versions of postgresql installed 8.4.18 and 9.1.12, but only 9.x is
in use.
I get following err
Thanks David for your quick response. My original objective was to get the
value of a particular node in xml which is stored as text datatype in the
table.
For example :
--16
I want to extract the value of amperage as '16'. Like that I may have many
nodes in xml want to get the report to show
Hi,
My current database version is "PostgreSQL 9.1.11 on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat
4.4.7-3), 64-bit".
I am trying to use function xpath in my query and got following error.
"ERROR: function xpath(unknown, text) does not exist at character 8
HINT:
Thanks Jeff for your quick response.
I inherited this system and they had cron job which uses pg_dump for back
up. I recently used to rsync to bring back my hot standby when it was out of
sync and offline for few days because of space issue. That is when the
thought that I might be able to use rsy
I need to clone production database to development server ? What is the best
and simplest way to achieve that? Both my production and development
postgres versions are same. Will copy over data folder using rsync work?
Thanks in advance.
--
View this message in context:
http://postgresql.1045
