On Monday 19 December 2011 17:15:49 Scott Toland wrote:
> the problem is the old schema was
> an ASCII neutral zone, and the new server has the schema set for UTF-8
You have to convert the Dump:
http://blog.endpoint.com/2011/12/sanitizing-supposed-utf-8-data.html
HTH, Jens
--
Sent via pgsql-ad
On Tuesday 08 March 2011 15:02:57 Gnanakumar wrote:
Hi,
> How do I get the schema name in which TEMPORARY table is created using
> "CREATE TEMP TABLE mytable " syntax?
select n.nspname from pg_class c join pg_namespace n on n.oid=c.relnamespace
where c.relname ='foo' and n.nspname like 'pg_
Am Dienstag 31 August 2010 11:36:31 schrieb Silvio Brandani:
> Is it possible to have multiple host destinations in the archive_command
> parameter of postgresql.conf to be able to mantain 2 standby datbase
> with write ahead log???
You have to write a shell script and run this as archive command
Am Dienstag 24 August 2010 11:35:43 schrieb Kieren Scott:
Hi Kieren,
> but I was wondering if there were any good tools available
> for monitoring such things as whether all of my postgres cluster's were up
> and running
Have a look for nagios check_postgres.
Rgds, Jens
--
Affinitas GmbH
Am Dienstag 13 Juli 2010 11:30:20 schrieb Silvio Brandani:
> We need to upgrade the postgres running on our production system under
> Red Hat Enterprise Linux Server release 5.1 from version 8.1.21 to
> version 8.3.6.
Have a look here:
http://wiki.postgresql.org/wiki/RPM_Installation#How_do_I_per
es all the links
in /etc/rc*
Please check if they exist:
ls /etc/rc*/*postgres*
Regards,
Jens Wilke
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Am Dienstag 06 April 2010 20:38:46 schrieb Tom Lane:
> Usually, just installing a package is not enough to make it autostart
> at boot
This is not true for debian and ubuntu.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
