've been using it for a few months, and it's fine. You *ALWAYS* want
to be using the latest
version within the series. The PostgreSQL project releases those to fix
bugs.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683
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
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
l run 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
f the END of the vacuum / analyze.
(I'm the author of the patch).
--
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 broad
27;s my entire
/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] O
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
why this happened,
>> and if anyone know ways to prevent this from happening 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 hun
could be the best way to migrate?
> 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 787
>
> Thanks for any help,
>
> Chris
>
> 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
on in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete all copies from any
computer.
-- Larry Rosenman, Database Support Engineer, E-Mail:
[EMAIL PROTECTED] Pervasive So
nto test2 (name) values('myname2'); ERROR: duplicate key
> violates unique constraint "test2_pkey"
> sys=>
>
>
> Why is it so ?
>
>
>
> Thanx
>
> Michal
Because you didn't let the serial column do it's magic.
Try:
Insert
(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
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
the "Signing Bonus" Sweepstakes
http://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
rameter that can 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
adcast)---
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
ANSI-isms ...
Actually, I *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.l
at least under FreeBSD
(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
--
and \dS 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 Rosenm
u Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>
> ---(end of broadcast)-------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
--
Larry Rosenman http://
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
4C34 3E1D 0C1C
>
> "Let your light so shine before men, that they may see
> your good works, and glorify your Father which is in
> heaven." Matthew 5:16
>
>
> ---(end of broadcast)---
> TI
l programming work. Sorry.
The UDK FS 7.1.1b DOES accept // comments.
The other issue is more 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
y is this so ?
>
> Sean
--
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-6749
shoes.
> That way, when you criticize them, you're a mile away and you have their
> shoes.
>
> -Original Message-
> From: Larry Rosenman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 09, 2000 7:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [
IL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Before you criticize someone, you 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-41
database: template1
template1=> EOF
$ psql
raddr->sa.sa_family = 0
No pg_hba.conf entry for host localhost, user postgres, database postgres
Connection to database 'postgres' failed.
No pg_hba.conf entry for host localhost, user postgres, database postgres
$
Patrick Welche wrote
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
0 { start | stop }"
;;
esac
Robert 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
> > Passw
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
30 matches
Mail list logo
