Re: [ADMIN] Can't dump and restore

Tom, You're correct, the new database was being created as UNICODE instead of SQL_ASCII. I'd never messed with encoding before, but I guess that the default was changed some time after I originally made the database on 6.x. Stupid mistake. :) Thanks a bundle for your help! Pe

Re: [ADMIN] Can't dump and restore

So, long and short, I think that everything should be SQL_ASCII, but even when it is, I get the error. Thanks, Peter Darley -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 01, 2005 1:22 PM To: Peter Darley Cc: Pgsql-Admin Subject: Re: [ADMIN] Can&#x

[ADMIN] Can't dump and restore

Does anyone have any idea of what might be going on here? Is this likely to be something that I can fix, or should I start taring up the directory when I need to do backups? Thanks, Peter Darley ---(end of broadcast)--- TIP 4:

Re: [ADMIN] Encrypted Disks

Scott, I was hoping that someone with some experience could comment on how much this would slow down PostgreSQL, or weither it is likely to introduce some instabilities... Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott

Re: [ADMIN] Encrypted Disks

long and short, I understand that it only protects the data while the drive is not mounted. Thanks, Peter -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 8:24 AM To: Peter Darley Cc: Pgsql-Admin Subject: Re: [ADMIN] Encrypted Disks On Thu,

[ADMIN] Encrypted Disks

overy from a crash, etc? Thanks, Peter Darley ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Error on Vacuum Full

Friends, To answer the obvious question, I'm using PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96. Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of Peter Darley Sent: Monday, October 28, 2002

[ADMIN] Error on Vacuum Full

a message from 2001 that wasn't really answered. How big a deal is this, and what can I do about it? Thanks, Peter Darley ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Process balancing on smp db server/apache web server

ly? Thanks, Peter Darley ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [ADMIN] ODBC Problem

but I can't find any documentation on that anywhere. As before, any help would be greatly appreciated. Thanks, Peter Darley Table "answers_bool" Column | Type |

[ADMIN] ODBC Problem

ine stopped the process because you and another user are attempting to change the same data at the same time". I'm able to delete/change data from psql and from my Perl scripts. Any suggestions on what I might have done wrong? Thanks, Peter Darley ---

Re: [ADMIN] slow inserts

   DBI->connect("dbi:Pg:dbname=dbname;host=hostname", 'user', 'password', {AutoCommit => 0}) Thanks,Peter Darley -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi KanterSent: Wednesday, March 20, 2002 11:19 AMTo: Post

Re: [ADMIN] Linux Distributions

Ian, By better I guess I mean faster. I'm looking to get the most speed out of my database without having to invest in new hardware. Thanks, Peter Darley -Original Message- From: Ian Barwick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:17 PM To: Peter D

Re: [ADMIN] Linux Distributions

Andy, I've got nothing against FreeBSD, except that I'm familiar with Linux and not with BSD. What is it about FreeBSD that is going to make it faster than Linux? Any idea where I can find some comparative benchmarks? Thanks, Peter Darley -Original Message- Fr

[ADMIN] Linux Distributions

Friends, I'm wondering if there is a specific Linux distribution for the x86 that will provide a better PostgreSQL server than the other ones? Thanks, Peter Darley ---(end of broadcast)--- TIP 2: you can get off all lists at once wit

Re: [ADMIN] Journaling file systems

Jeff (or anyone else), Is there some kind of file system (for Linux) that will provide better performance than ext2? XFS or ReiserFS maybe? Thanks, Peter Darley -Original Message- From: Jeff Self [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 8:22 AM To: Peter Darley

[ADMIN] Journaling file systems

Friends, I'm wondering if a journaling file system, like ext3, will make much difference with the speed or reliability of PostgreSQL? Is it worth the work to switch over? Thanks, Peter Darley ---(end of broadcast)--- TIP 1: subscrib

Re: [ADMIN] tuning SQL

ter than your first query), since it's using in, but I'm sure that someone can suggest something faster. Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Zhang, Anna Sent: Tuesday, January 29, 2002 7:57 AM To: [EMAIL PROTECTE

[ADMIN] Postgresql optimization

e ramification for this, so I just wanted to check with y'all and see if you thought I would be getting myself in trouble... Thanks, Peter Darley ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster