[ADMIN] FW: Linking databases.

eb.column", but just can't find the right syntax... I'm using 7.2 thanks geoff --- This message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged m

FW: [ADMIN] FW: Linking databases.

ted a user it would cascade and delete the users_access records. are you saying this is impossible? if so, are their plans for this to be made a feature in a future release? many thanks Geoff -Original Message- From: omid omoomi [mailto:[EMAIL PROTECTED]] Sent: 11 July 2002 10:55 To: [

[ADMIN] Database Diagrams.

ching with the wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs on a debian linux server. TIA Geoff --- This message is intended only for the person or entity to which it is addressed

[ADMIN] Triggers/Rules?

really really appreciate some pointers on how to achieve my goal and relieve me of this thorn in my side! thanks very much geoff ellis ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] Function Problem

the end of the function... RETURN NULL; END Can anyone see what I've done wrong in there? TIA Geoff Here is my trigger and function. trigger == CREATE TRIGGER doc_status_trig AFTER UPDATE ON document_status FOR EACH ROW EXECUTE PROCEDURE mon_sum_update() function == CREATE

Re: [ADMIN] Function Problem

Thanks guys, I've cracked it now... yeah, a lot of syntax errors, but to be honest, I never got to look at the pl syntax page. Thanks to Jakub for the link, it helped solve the problem... thanks again.. Geoff -Original Message- From: Robert Treat [mailto:[EMAIL PROTECTED]] Sen

[ADMIN] Installation Error - binary - PostgreSQL 8.1.2

. Can anyone help? Geoff. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [ADMIN] Installation Error - binary - PostgreSQL 8.1.2

Thanks for the help, PostgreSQL and/or the installer crashes at startup, fails to start or hangs on start but the remedy identified in the FAQ does not help, any other suggestions? > PostgreSQL 8.1.2 binary > O/S Windows XP Pro > > Trying to install via the msi but fails get following error in

[ADMIN] Disk usage in postgresql 8.1.4

l This is Postresql version 8.1.4 on a slightly modified version of RHEL 4 (2.6.17 kernel). Thanks, Geoff.

[ADMIN] disk usage spike

lier (4am) that morning.    Is it possible the spike was caused by autovacuum re-indexing the pg_largeobject table? Thanks, Geoff.

Re: [ADMIN] disk usage spike

Unfortunately I didn't notice the problem until I saw the logs today, and by then it was back tor normal.  Is it safe to assume this is abnormal behaviour? Geoff. - Original Message From: Tom Lane <[EMAIL PROTECTED]>To: Geoff Parker <[EMAIL PROTECTED]>Cc: pgsql ad

Re: [ADMIN] Multiple auth types for a connection

implications of SSL vs non-SSL connectivity, wouldn't it be possible to have something like: hostnosslall all 0.0.0.0/0 krb5 hostssl all all 0.0.0.0/0 md5 ... and then have sslmode set to prefer or allow on the client

Re: [ADMIN] How overcome wait for vacuum full?

ought to be able to reclaim disk space by the copy/drop original/rename procedure, but that gets hard to manage if you have triggers or foreign keys on the table in question. You might want to use CREATE TABLE table_copy (LIKE orig_table) to preserve column defaults if you go down tha

Re: [ADMIN] How overcome wait for vacuum full?

from mytable_old. I'm afraid you'll have to sort out manually what these should be. */ 7.3.8 is quite seriously old. 7.3.19 is the latest in that tree if you must stick with it. HTH, Geoff ---(end of broadcast)--- TIP 1: if posting/

Re: [ADMIN] configuration kerberos in Postgre sql

that matter, /etc/hostname and /etc/resolv.conf would be good to see too because of their importance here. HTH, Geoff - Geoff Tolley DBA/Systems Administrator YouGovPolimetrix 285 Hamilton Avenue Suite 200 Palo Alto, CA 94301 geoff.tol...@yougov.com http://www.yougov.com/ -- Sent via

[ADMIN] Alter column varchar(n) via updating pg_attribute

? (Naturally I'm also in the process of testing). Thanks, Geoff --- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] diskspace

. I expected a little overhead from what I'd read before the migration but that's a fairly huge difference. As I said, sorry if I've missed the obvious "use loads of extra space" setting but I'd appreciate any suggestion as to what that setting might be called :) Cheers Geoff

Re: [ADMIN] diskspace

HeaderData). Given page size of 8kb that would imply page headers of about 3.3MB over a 611MB table. Even with some bytes for alignment I'm Still not seeing where 230MB (more than the space taken by the data itself) of my disk is gone. Thanks! Geoff

Re: [ADMIN] diskspace

On 5 February 2013 20:33, Geoff Winkless wrote: > http://www.postgresql.org/docs/9.2/static/storage-page-layout.html gives > detail... > > Let's say around 249MB (23 bytes per row, according to that page) for the > columns you mention, so that leaves 234MB unexplained. > &

Re: [ADMIN] diskspace

gt; out what is where and where the space went? > I haven't; I will do for interest's sake, thanks for the suggestion. Geoff

Re: [ADMIN] diskspace

On 6 February 2013 11:12, Geoff Winkless wrote: > On 6 February 2013 11:04, Albe Laurenz wrote: > >> Have you tried using pg_filedump >> (http://pgfoundry.org/frs/?group_id=1000541) >> to dump a page or two of your table and figure >> out what is where and where th

Re: [ADMIN] top posting?

s an average of about 8 a day replying to a guy trolling on about a 20-year-old argument . Can we put it to bed now please? Geoff

[ADMIN] Function problem.

help me here, I've looked through the 7.3rc1 Docs shipped with pgadmin and can't quite see what I'm after... thanks Geoff ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Date Problem on Imports to 7.2.1 [ SOLVED ]

lt but this default can be changed at compile time or at run time. thanks. Geoff -Original Message- From: Geoff Ellis [mailto:[EMAIL PROTECTED] Sent: 27 August 2003 13:38 To: 'Pgsql-Admin (E-mail)' Subject: Date Problem on Imports to 7.2.1 We have some date problems when impor

[ADMIN] Date Problem on Imports to 7.2.1

y! Is there a flag or setting within the database that will allow us to import the date correctly? thanks in anticipation.. Geoff Ellis ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[ADMIN] Testing for a record before update or insert without using a function.

Is it possible to test if a record exists in a table and then if it does do an update on that table or if it doesn't do an insert ? I've looked around the documents and it seems everything points towards a function? Is this the only way or has someone done this before.....