Re: [ADMIN] check to see when tables were last vacummed

They were added in 8.2 by me. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql

Re: [ADMIN] PostgreSQL and ZFS

I'm running on ZFS on a lightly loaded FreeBSD 7 box, and it's fine. I did give ZFS the hint with recordsize=8K on the data directory/fs, but nothing else. (other than the usual caveats with ZFS on FreeBSD (I'm on amd64)). LER -- Larry Rosenman http

Re: [ADMIN] PostgreSQL on 64-bit Windows

on 64-bit windows but in 32bit mode. I know from first hand experience that it runs as a 32-bit app on XP 64. LER Joshua D. Drake ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Larry Rosenman http

Re: [ADMIN] [PERFORM] autovacuum on a -mostly- r/o table

). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Building new FreeBSD box - some assistance needed

tire /boot/loader.conf file). How may I help? LER --Larry Rosenman http://www.lerctr.org/~lerPhone: +1 512-248-2683 E-Mail: ler@lerctr.orgUS Mail: 430 Valona Loop, Round Rock, TX 78681-3893 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin KrajmalnikSent: Monday, July 31,

Re: [ADMIN] PostgreSQL 8.1.3/Windows

They are the 1GB segments of your tables. You should NOT delete them. LER --Larry Rosenman Database Support EngineerPERVASIVE SOFTWARE. INC.12365B RIATA TRACE PKWY3015AUSTIN TX 78727-6531Tel: 512.231.6173Fax: 512.231.6597Email: [EMAIL PROTECTED]Web: www.pervasive.com From: [EMAIL

Re: [ADMIN] strange hung processes

again. If it's not sensitive information, what does this show? lsof | grep 'pid of hung process' from the save-a-process committee: lsof -p 'pid of hung process' will give the same info :) LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B

Re: [ADMIN] Migration from PG 7.1.3 to 8.1.1 with blobs

? Thanks for your help. a quick look around found: http://archives.postgresql.org/pgsql-patches/2004-11/msg00309.php Might be useful. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax

Re: [ADMIN] What are these files?

PG 7.3.4 contrib/oid2name is what you need. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.459.1309 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---(end

Re: [ADMIN] SERIAL type not autoincremented

the serial column do it's magic. Try: Insert into test2(name) values('myname'); Insert into test2(name) values('myname2'); That should work. Always let a serial column pick the number. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [ADMIN] Veritas Filesystem

of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail

Re: [ADMIN] [PERFORM] Postgres on Netapp

://hotjobs.sweepstakes.yahoo.com/signingbonus ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905

Re: [ADMIN] pg_atoi: zero-length string

be set)? Regards, Dani ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail

Re: [ADMIN] 7.3.2 to 7.3.4 upgrade

)--- TIP 7: don't forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description

Re: Fw: [ADMIN] Case Insensitive Test

*THINK* C99 allows // comments, but that's neither here nor there. Any pre-C99 Non-GCC compiler won't allow it (I'm one of the aforementioned beta testers, I use the SCO cc (native) compiler on UnixWare)). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

(its disabled by default) ... check in your BIOS though, I *thought* I heard mention that there is a setting in there to disable it, but have never looked :( I thought you could only enable/disable hyperthreading in the bios. The OS can disable/enable it as well. LER -- Larry Rosenman

Re: [ADMIN] list schema

are already taken, and there was no good proposal for what to use instead. Any thoughts? \dn for NameSpace? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman http

Re: [ADMIN] Opening 5432 port

---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX

Re: [ADMIN] Password recover

On Sat, 2002-06-22 at 22:03, Peter Arzamendi wrote: Is there a way to recover the sa password? What version of PostgreSQL? Thanks, Pete -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905

Re: [SQL] [ADMIN] Syslog

, and glorify your Father which is in heaven. Matthew 5:16 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Larry Rosenman http

Re: [ADMIN] 1)Can't compile with ODBC support. 2)FATAL 1: AllocSetAlloc() on Pentium computer.

serious. LER -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [ADMIN] large classes (tables)

should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044

[ADMIN] Re: [NOVICE] createdb problem

J. Sprawls wrote: On Sun, 14 Nov 1999, Larry Rosenman wrote: Here ya go: $ su - postmaster UX:su: ERROR: Unknown user id: postmaster $ su - postgres Password: $ postmaster -i [1] 18803 $ psql No pg_hba.conf entry for host localhost, user postgres, database pos

[ADMIN] Re: [NOVICE] createdb problem

THis is how it starts on my 2.1.3 system. SOMETHING HAS CHANGED between UnixWare 7.1.0 and 2.1.3 and 6.5.3 Since I'm not the only one seeing this, I suspect it is the code and the interaction of the OS. Larry Robert J. Sprawls wrote: On Sun, 14 Nov 1999, Larry Rosenman wrote: Here

[ADMIN] 6.5.3/doesn't recognize localhost in pg_hba.conf

HELP! Just recompiled PostgreSQL 6.5.3 on UnixWare 7.1.0 on a P-III. Followed all the steps, but when I try to connect, it says that there is NO pg_hba.conf entry, but there is. Anyone else see this? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812