Sorry for the double post. Our email server had some problems
overnight. Feel free to ignore this. We're still working on the issue
using suggestions from last week, and we're seeing some improvements.
Ryan
-Original Message-----
From: Ryan Wells
Sent: Friday, April 11, 2008
We think there must be something we're doing wrong, but none of our
searches have turned up anything (we likely just don't know the right
search terms). Hopefully, either there's a server setting or pg_dump
option we need to change, but we're open to design changes if necessary.
C
CTED]
Sent: Mon 4/14/2008 7:58 PM
To: Phillip Smith
Cc: Ryan Wells; [email protected]
Subject: Re: [ADMIN] Slow pg_dump
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>> Here's my interpretation of those results: the TOAST tables for
>> our image f
the
backup. Please correct me if I'm wrong there.
If we can't find a workable balance using pg_dump, then it looks like
our next best alternative may be a utility to handle filesystem backups,
which is a little scary for on-site, user-controlled servers.
Ryan
-Original Message-
Fr
erver setting or pg_dump option we need to
change, but we're open to design changes if necessary.
Can anyone who has dealt with this before advise us?
Thanks!
Ryan
tried adjusting the buffer sizes in postgresql.conf and the
Windows registry tweak that one site suggested, but neither of those
made any apparent difference.
Naturally I'm hoping this is a common, well-known issue with an easy
fix, but of course I don't expect that to be the case. :-)
Th
2.dll
* krb5_32.dll
* libiconv-2.dll
* libintl-2.dll
* libpq.dll
After that my pgdb working like a charm.
HTH,
Ryan Davis
Acceleration.net
Director of Programming Services
2831 NW 41st street, suite B
Gainesville, FL 32606
Office: 352-335-6500 x 124
Fax: 352-335-6506
ekzept wrote:
stmaster process and it opens the krb5.conf file,
but does not appear to ever connect to the KDC before returning the
error to the client:
$ psql -h db -l
psql: Kerberos 5 authentication failed
Any ideas?
--
Ryan Underwood, <[EMAIL PROTECTED]>
signature.asc
Description: Digital signature
gcrypto folder in the source tree.
Hope that helps.
- Ryan
--
Ryan Cavicchioni
GPG ID: C271BCA8
GPG Public Key: http://confabulator.net/gpg/ryan.asc
GPG Fingerprint: 83E4 2495 6194 0F66 ED85 22B4 4CC0 DA01 C271 BCA8
---(end of broadcast)---
TIP 8: explain analyze is your friend
Piotr Kabath wrote:
> UNSUSCRIBE
>
>
> Internet to skuteczna metoda poszukiwania pracy! Zajrzyj do serwisu
> Praca.wp.pl - Mamy dla Ciebie setki nowych ogłoszeń każdego dnia!
> http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Frobota.
hi,
I am having trying to install Postgres 7.4.5, I have gmake 3.76.1 installed.
I have completed following steps:
./configure --prefix=/opt/local --enable-multibyte --enable-unicode
--with-java --without-readline
make
su rootr
make install
adduser postgres
mkdir /opt/local/pgsql
It's possible to get process ids for clients using something like ps
-ef | grep postgres. I wonder, is it safe to use kill to terminate
those threads? If this doesn't mess up the database, it might work.
Hadley Willan wrote:
Thanks for that, however that's quite heavy handed in that it
se/application", but if anybody has any quick rules of thumb, I'd
love to hear them.
I've found a lot of advice on the web for optimizing postgres databases,
and so I don't need that kind of info.
Thanks in advance.
Ryan
---(end of broadcast)--
Does anyone know of a good data modeler preferably for linux that works
with PostgreSQL?
Chris Ryan
1. A FAQ can be found at http://www.postgresql.org/docs/faq-english.html,
the a book is at http://www.postgresql.org/docs/awbook.html, searchable
archives of lists at http://www.postgresql.org/gen-info.html and lots of
documentation accessable via postgresql.org under the 'user's lounge'.
2. My
It's not normally a good idea to move/remove files that a process has an
open file handle for. The safest way is to copy the file to a new
location/name then cat /dev/null > logfile
Chris
Mitch Vincent wrote:
>
> Can you move the logfile then touch the original file to create an empty
> one?
>
I did have PG 6.5.3 I think. I moved it out of the directory it was in and
put it in a pgsql_old directory. Is there something else I need to do to
get rid of it? At this point what should I do to get rid of all of them?
Thanks for the help.
-ryan
- Original Message -
From: "St
e following response:
/usr/bin/psql: error in loading shared libraries:
/usr/bin/psql: undefined symbol: pg_encoding_to_charcreatedb: database
creation failed
any help with this would be greatly
appreciated. thanks in advance
-ryan
Alpha patches into the main
tree is a bit higher priority at the moment. TTYL.
---
| "For to me to live is Christ, and to die is gain."|
|--- Philippians 1:21 (KJV) |
to die is gain."|
|--- Philippians 1:21 (KJV) |
---
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---
Thanks,
Rich
On Fri, 29 Oct 1999, Chris Albertson wrote:
>
> > >
> > > Date: Thu, 28 Oct 1999 01:11:32 -0700
> > > From: Rich Ryan <[EMAIL PROTECTED]>
> > > Subject: HSA (Highly Scalable Architecture) Distribution and
replication
> > >
>
he fields which appear in a WHERE clause,
using
> > > either hash or btree, as recommended by the docs. The only operator I
> > > couldn't find was for a money type.
> > > I don't use order by, although I'd like to, because the docs said that
&g
goes
out or something.
- Original Message -
From: Peter Galbavy <[EMAIL PROTECTED]>
To: Rich Ryan <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 1999 1:31 AM
Subject: Re: [ADMIN] HSA (Highly Scalable Architecture) Distribution and
replication
>
Has anyone written a HSA e-commerce solution using postgres? In english,
this means I want more than one server running postgres with the same
database(s). I get lots and lots of queries, and it's just too much for one
poor machine to handle. I get far less inserts, updates, and deletions, but
reg
Have you tried an ipcclean?
Just a thought.
-Ryan
> I am running Slackware 3.5, PostgreSQL 6.4.
> I was able to start and run PostgreSQL and run the initial regression
> test with only a failure in geometry and misc.
> Overall it worked well.
> I kill the postmaster process
Hi,
I've got a bit of a complicated problem here with a postgres user
already existing on the network I'm on (and having /dev/null as its
home). Is there a way I can something other than ``postgres'' as a name
for the Postgres superuser and group name? I don't know why anybody
would create a po
26 matches
Mail list logo
