Re: [ADMIN] Problem restoring a dump

On Wed, Sep 14, 2011 at 03:56:27AM +0200, Craig Ringer wrote: You can't change the encoding of a database in-place. Thanks Craig and all the other that responded. Enjoy your day. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data

[ADMIN] Problem restoring a dump

in LATIN1 I have changed the client-encoding of psql to UTF8 but I see after the restore of the dump the encoding is still LATIN1. How do I overcome this? Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor

Re: [ADMIN] Problem restoring a dump

. Question: Can I change the encoding system of an existing database? If so, how? Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation

Re: [ADMIN] Out of memory

with more free space and I deleted and recreated the database. I could successfully import the data now. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research

[ADMIN] Out of memory

? There are several foreign keys in the database. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit

Re: [ADMIN] visualizing database schema - png/jpeg?

On Wed, May 18, 2011 at 09:09:19PM +0200, neubyr wrote: Anyone knows of tools that can generate PNG/JPEG image from pgsql database schema? I am usine postgresql-autodoc on Debian. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager

[ADMIN] Indexing error

maximum 2712 for index fltx_adr Creating Index: FK_authlink1 I have seen some old references and bug reports to this 2712 limit. Is there a way to overcome it? I am using 8.4.4 on Debian. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data

[ADMIN] Corrupted database - how to recover

I recover from a situation like this? Regards Johann -- Johann Spies Telefoon: 021-808 4599 Informasietegnologie, Universiteit van Stellenbosch All that the Father giveth me shall come to me; and him that cometh to me I will in no wise cast out

Re: [ADMIN] Corrupted database - how to recover

this type of problem. Fortunately the data was not that critical. I agree that pitr should be a part of any mission critical setup. Regards Johann -- Johann Spies Telefoon: 021-808 4599 Informasietegnologie, Universiteit van Stellenbosch All that the Father giveth me shall come to me

Re: [ADMIN] PostgreSQL 8.3

to connect to the database? And did you configure the connection details correctly within PGAdminIII? Regards Johann -- Johann Spies Telefoon: 021-808 4599 Informasietegnologie, Universiteit van Stellenbosch Honour the LORD with thy substance, and with the firstfruits of all thine

Re: [ADMIN] PostgreSQL monitoring

postgres env.dbhost localhost env.dbname exilog env.dbpass xx env.dbuser exilog Any idea why I get the error message? Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Neither is there salvation in any other

Re: [ADMIN] pgAdmin III

On Wed, Jul 30, 2008 at 09:15:38PM -0500, Jim Toth wrote: I've installed PostgreSql 8.3 on Ubuntu 8.04. When I click on the pgAdmin III link, nothing happens. I'm a newbie here, any help would be appreciated... Did you install pgadmin3 and pgadmin3-data also? Regards Johann -- Johann Spies

Re: [ADMIN] pgAdmin III

On Thu, Jul 31, 2008 at 06:02:05AM -0500, Jim Toth wrote: Not explicitly, are there separate installs for those? Yes Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Have not I commanded thee? Be strong and of a good

Re: [ADMIN] Handling large volumes of data

On Tue, Apr 08, 2008 at 12:01:14PM +0200, Michael Monnerie wrote: On Dienstag, 8. April 2008 Johann Spies wrote: This took about a week on a 2xCPU quadcore server with 8Gb RAM. This is not the most interesting thing here. What disk I/O subsystem do you use? At least a hardware RAID

[ADMIN] Handling large volumes of data

the older tables as necessary. Any advice on how to best handle this kind of setup will be appreciated. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Be careful for nothing; but in every thing by prayer and supplication

Re: [ADMIN] Handling large volumes of data

Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Be careful for nothing; but in every thing by prayer and supplication with thanksgiving let your requests be made known unto God. And the peace of God, which passeth all

Re: [ADMIN] PostgreSQL and virtualization

running. However, it will also be slower than Xen. If you are just testing, use VMWare. You can also look at VirtualBox (www.virtualbox.org). I my experience it is as easy as VMWare and faster. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit

Re: [ADMIN] ERROR: invalid memory alloc request size

On Mon, May 28, 2007 at 11:18:37AM -0400, Tom Lane wrote: L Alvaro Herrera [EMAIL PROTECTED] writes: Johann Spies wrote: #3 0x005ff1c8 in perform_default_encoding_conversion ( src=0x2b881e87f040 \2007-04-20\ \18:07:06\ \192.168.0.100\ \73\ \http://www.kerkbode.co.za/kerkbode

Re: [ADMIN] ERROR: invalid memory alloc request size

On Mon, May 28, 2007 at 11:18:37AM -0400, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Johann Spies wrote: #3 0x005ff1c8 in perform_default_encoding_conversion ( src=0x2b881e87f040 \2007-04-20\ \18:07:06\ \192.168.0.100\ \73\ \http://www.kerkbode.co.za/kerkbode

[ADMIN] Syntax in postgresql.conf

database server * Error: Invalid line 53 in /etc/postgresql/8.1/main/postgresql.conf Why? Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Wait on the LORD; be of good courage, and he shall strengthen thine heart; wait, I

Re: [ADMIN] Syntax in postgresql.conf

On Mon, May 28, 2007 at 09:05:37PM +1000, Phillip Smith wrote: I believe you would need it to be: listen_addresses = '192.168.0.1,localhost' ie, Don't close the quotes between your CSV's Thanks Phillip. That did it. Regards Johann -- Johann Spies Telefoon: 021-808 4036

Re: [ADMIN] ERROR: invalid memory alloc request size

in main (argc=3, argv=value optimized out) at main.c:188 Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Wait on the LORD; be of good courage, and he shall strengthen thine heart; wait, I say, on the LORD

Re: [ADMIN] ERROR: invalid memory alloc request size

, fast server and got exactly the same error. Maybe I should try another database. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch O come, let us worship and bow down; let us kneel before the LORD our maker

Re: [ADMIN] ERROR: invalid memory alloc request size

in FreeQueryDesc () #9 0x081f84d9 in PortalRun () #10 0x081f3b51 in pg_parse_query () #11 0x081f5296 in PostgresMain () #12 0x081c8a1f in ClosePostmasterPorts () #13 0x081c9924 in PostmasterMain () #14 0x081823b5 in main () It looks the same as the previous one to me. Regards Johann -- Johann Spies

Re: [ADMIN] ERROR: invalid memory alloc request size

0x081c9924 in PostmasterMain () #14 0x081823b5 in main () Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch Jesus said unto her, I am the resurrection, and the life. He that believeth in me, though he were dead

Re: [ADMIN] ERROR: invalid memory alloc request size

* Tom Lane [EMAIL PROTECTED] [070514 16:36]: Johann Spies [EMAIL PROTECTED] writes: I am using postgresql 8.1 on Debian Stable. 8.1.what? I have tried it now on 8.2.4-1 and the error happened exactly at the same place and with the same bogus request size again. Regards Johann -- Johann

Re: [ADMIN] ERROR: invalid memory alloc request size

/to/postgres PID-of-backend Which pg-process? The Postmaster or psql? I have done this for the Postmaster now but gdb b errfinish gdb cont ... wait for breakpoint to be hit ... This did not happen although the error occurred (after a few hours). Regards Johann -- Johann Spies

[ADMIN] ERROR: invalid memory alloc request size

btree (datum, tyd) The server is an old HP LP 2000 with 1G of RAM. Maybe that is the problem, but then, how could I copy the data into the other 4 tables without similar problems? Any idea on how to solve this? Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie

Re: [ADMIN] ERROR: invalid memory alloc request size

On Mon, May 14, 2007 at 10:34:18AM -0400, Tom Lane wrote: Johann Spies [EMAIL PROTECTED] writes: I am using postgresql 8.1 on Debian Stable. 8.1.what? Sorry. The version is 8.1.8-1 psql:laai_squid_logs:4: ERROR: invalid memory alloc request size 1350958157 CONTEXT: COPY squidlogs

Re: [ADMIN] Warm standby (solved)

On Tue, Feb 27, 2007 at 10:34:37AM +0200, Johann Spies wrote: I want to setup a form of replication for postgresql using the warm standby option (http://www.postgresql.org/docs/8.2/static/warm-standby.html) I have had success to let server A to copy the WAL logs to server B (the standby

[ADMIN] Warm standby

Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch If we confess our sins, he is faithful and just to forgive us our sins, and to cleanse us from all unrighteousness. I John 1:9 ---(end