[ADMIN] Warm standby

ncomplete startup packet It does not seem to do anything about the WAL logs from the other server. What am I missing? Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "If we confess our sins, he is fai

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 t

[ADMIN] ERROR: invalid memory alloc request size

datum | date | not null tyd| time without time zone | not null bron | inet | not null bytes | bigint | url| character varying | Indexes: "squidbron" btree (bron, datum, tyd) "squidtyd" btree (datum, ty

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 reque

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

On Mon, May 14, 2007 at 05:13:25PM +0200, Johann Spies wrote: > > 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.wh

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

r occurred (after a few hours). Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Let not your heart be troubled: ye believe in God, believe also in me." John 14:1 ---(end of broa

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 reque

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

s () #13 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 dea

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

esMain () #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 Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenb

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

e same process on a new, 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 b

[ADMIN] Syntax in postgresql.conf

ostgresql-8.1 restart * Restarting PostgreSQL 8.1 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 co

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

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

20 "js") at postgres.c:3424 #12 0x000000556b6a in ServerLoop () at postmaster.c:2931 #13 0x00557707 in PostmasterMain (argc=3, argv=0x877370) at postmaster.c:963 #14 0x00519403 in main (argc=3, argv=) at main.c:188 Regards Johann -- Johann Spies Telefoon:

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\" \&

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\" \&

Re: [ADMIN] PostgreSQL and virtualization

tried > > anything like this? > > Vmware server is free (as in beer) as it by far the easiest to get > 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 i

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 lea

[ADMIN] Handling large volumes of data

able for each day and then drop 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 ever

Re: [ADMIN] Handling large volumes of data

know. Regards 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,

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 Jo

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 an

Re: [ADMIN] PostgreSQL monitoring

lugin-conf.d/munin-node [pg_exilog*] user 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 "

Re: [ADMIN] PostgreSQL 8.3

d be able 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 f

[ADMIN] Corrupted database - how to recover

at if it was. How do 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

Re: [ADMIN] Corrupted database - how to recover

e I experienced 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 giv

[ADMIN] Indexing error

ze 2768 exceeds 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 46

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 m

[ADMIN] Out of memory

27; lines? And the memory problem? 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, Sci

Re: [ADMIN] Out of memory

a difference: moved the database to a partition 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 Evaluasi

[ADMIN] Problem restoring a dump

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 Evaluasie, Wet

Re: [ADMIN] Problem restoring a dump

t went well. 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 Eval

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 Databestuur