On Monday 10 April 2006 07:18, sandhya wrote:
> Hi...
> I want to know more about alter user /creating users.I am facing error if
> i give user with Login/Nologin..Why is it so? But it is working fine for
> Createdb/NoCreatedb.etc.
>
> sample=# ALTER user sandhya with LOGIN;
> ERROR: syntax error
I pulled down the oralink contrib module from the pg foundry but it has no docs.
Anyone know of ant docs/help/etc for this contrib module?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
what would be the easiest way to move databases from one postgresql
server to another?
Kevin
-01-2000 " and " 08:00:00 " , now is of couse not year 2000 and the
> time is also not 8 o'clock. Why? How should I correct this?
> I am using PostgreSQL in Linux system, and the date & time for Linux
> system are correct.
I'm not real sure, but I wou
of memory.
Any ideas?
-
Sincerely,
Kevin Meldorf
Magnitude Network
1525 West Homer #202
Chicago IL 60622
phn 773.645.3210 x286
fax 773.645.3211
+++
> Bohdan KRAVCHUK
> Wolfson College
> Barton Road, Cambridge CB3 9BB, ENGLAND
> Email: [EMAIL PROTECTED]
> ++++
- Kevin
Bryan Bateman wrote:
> Is it possible???
Yes, why not? :-)
Please see http://people.freebsd.org/~kevlo/postgres/portNT.html
- Kevin
e
database to all users on an ip, but I can't grant it to only one user.
Thanks in advance,
Kevin
e
database to all users on an ip, but I can't grant it to only one user.
Thanks in advance,
Kevin
ec elapsed 6.82
sec.INFO: vacuuming "public.fip_xl_switch"
I'm concerned about " 1555321 dead row versions cannot be removed
yet"
I'd be extremely grateful if anyone could cast some light on this.
Thanks, Kevin
the right direction to addressing such a problem
should it occur in the future?
Thanks,
Kevin
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/d
.
From what I see below, could I assume that the best method is to kill the
offending process in UNIX, and then postmaster should recognize there was a
problem and restart the database. Correct?
Thanks,
Kevin
From: Tom Lane <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] Question regarding bl
writing to the WAL? I don't need to have this enabled - because in
the event of a database crash, I would simply reload the data from the
source files as recovery.
Thanks,
Kevin
_
Dont just search. Find. Check out the ne
Does anyone have any ideas on a possible cause, or any diagnostic steps we
should take?
Thanks,
-Kevin
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t set to
"unlimited" were pipe size and open files. Is there any chance that the
error/rollback path in the code is leaking open files on the server? Is there
anything I should run during the test to watch for potential resource
exhaustion?
-Kevin
>>> Tom Lane <[E
is only showing
up on commit of a database transaction which follows close on the heels of a
rollback on the same connection, is there any chance that there is some very
small "settling time" needed for a rollback, and we're sometimes getting in
ahead of this?
-Kevin
>&
will allow the problem to show.
I welcome all suggestions on what to try or what to monitor.
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> 09/13/05 11:31 AM >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> One more thought -- I keep coming back to the fac
it
comes fast enough after the Statement.cancel, it receives the error
which is the subject of this thread.
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> 09/13/05 1:18 PM >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> I'm having a really hard time
One more thought on the topic -- in the particular case where we hit
this, the Statement did not have any requests active on its connection.
If the driver can determine this, it could return from the cancel method
without doing anything.
-Kevin
>>> Oliver Jowett <[EMAIL PROTECTE
,
Kevin
_
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
---(end of broadcast)---
TIP 6: explain analyze is
and the table has (for example) 500 records, but only 350 were copied to the
file, what is returned in i? Or is the only method to check that all the
data was exported correctly to wc -l the file and select count(*) to check
against what was supposed to be exported?
Thanks,
Kevin
From
g_statistic
gives me
ERROR: permission denied: "pg_statistic" is a system catalog
Is there any way to nuke pg_statistic (since its contents can be
recalculated anyway?)
Thanks,
--
Kevin Seghetti: E-Mail: [EMAIL PROTECTED], HTTP: www.tenetti.org
GPG public key: http://tenetti.org/cgi-bi
application.
This failure seems rather different from the one I previously posted,
since it was blocking on the application table, rather than
pg_constraint_contypid_index, and it did not wake up when all
other processes where stopped.
As before, both boxes are running 8.1beta2. Windows is not showing
e thorough.
-Kevin
---(end of broadcast)---
TIP 6: explain analyze is your friend
by an autovacuum process.
There were a few very small single-source tests under 8.0.3, but all
tests involving any significant load were under 8.1beta1 or 8.1beta2.
We did not see this in any of those small tests under 8.0.3.
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> 10/03/05 3:48
le to clean things up adequately. We have tried cluster, which
also worked -- but there doesn't seem to me to be any real
advantage over vacuum followed by reindex for our small, frequently
updated table, since it is rarely accessed sequentially. Am I missing
something there?
-Kevin
issue a few minutes ago.
-Kevin
>>> "Kevin Grittner" <[EMAIL PROTECTED]> 10/03/05 5:27 PM >>>
My goal is to avoid vacuum full in production. My understanding is
that it is never necessary if vacuums are done aggressively enough,
but I felt that while we were in
p with these on SuSE, let me know.
I hope this helps.
-Kevin
>>> faeiz <[EMAIL PROTECTED]> >>>
Dear Admins,
I am a new user, and I am running Suse Linux 9.3...
I have sucessfully installed PostgreSQL 8.0.3
The problem I am having is that my postgreSQL does not run in
Since you mentioned multiple backups per day, I thought you
might want to look at the the Point In Time Recovery option, as
well as the pg_dump approach.
http://www.postgresql.org/docs/8.0/interactive/backup.html
>>> Ferindo Middleton Jr <[EMAIL PROTECTED]> >>>
Are there tools available to auto
abase
was in use during this fix query. This table is normally insert-only.
The fix query was running for about an hour, during which time about
45,000 rows were inserted.
This looks to me like a database corruption. We can recover from the
Linux machine, but we're interested in the cause. (Management is
divided on using Linux versus Windows as our db server platform.) Any
suggestions on causes or what to check?
-Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
om/webapp/wcs/stores/servlet/ProductDisplay?productId=8741193&langId=-1
-Kevin
>>> Scott Marlowe <[EMAIL PROTECTED]> >>>
On Mon, 2005-11-14 at 17:20, Kevin Grittner wrote:
> running on dual hyperthreaded Xeons, with data on RAID5.
> ERROR: could not read block 6
t; WHERE (
dtr(> ("userId" <> UPPER("userId")) AND
dtr(> ("timestampValue" BETWEEN '2005-10-28' AND '2005-11-15'));
ERROR: could not read block 1118215 of relation 1663/16385/16483:
Invalid argument
-Kevin
>>> Joshua Mar
Could my issue be the same problem as this thread?:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00114.php
The references to "Invalid Argument" caught my eye. That thread
did start from a very different point, though.
-Kevin
>>> "Kevin Grittner" <[E
for "best
practices" advice from those experienced in this area.
-Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
read block 1482762 of relation 1663/16385/16483:
Invalid argument
So the block number is increasing each time. I'm inclined to think
that this is the result of the scan passing over rows added by itself.
-Kevin
>>> Qingqing Zhou <[EMAIL PROTECTED]> >>>
> I re
w)
I'm becoming more convinced that this happens as the UPDATE
runs into rows inserted by itself.
To respond to a concern expressed earllier -- all of our database
servers, including these two, use ECC memory.
-Kevin
>>> "Kevin Grittner" <[EMAIL PROTECTED]> >>&
that either it is a
coincidence or the restart cleared some bad state within postgres.
Is there anything that anyone wants me to do at this point, to try
to pin down a cause, or do I drop it here?
-Kevin
---(end of broadcast)---
TIP 2: Don'
ry so often (i.e. 500 - 1000
records). This way there will not be the overhead associated with an
extremely large transaction, and the script will complete much faster (I
have seen hours vs. minutes).
Hope this helps.
Kevin
Kevin Grittner wrote:
I got the error log working on Windows
I will patch, build, and run similar updates to try to hit the problem.
Hopefully I can have something to post later today.
-Kevin
>>> Qingqing Zhou <[EMAIL PROTECTED]> >>>
On Tue, 15 Nov 2005, Kevin Grittner wrote:
>
> Is there anything that anyone wants me to
Is there anything you would like me to include in my build for my
test runs, or any steps you would like me to take during the tests?
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> >>>
As I said before, we
really really need to find out what the Windows-level error code
arg 7)
How should I proceed?
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> Is there anything you would like me to include in my build for my
> test runs, or any steps you would like me to take during
Ran with this change. Didn't take long to hit it.
Let me know if there's anything else I can do.
[2005-11-16 11:59:29.015 ] 4904 LOG:
read failed on relation 1663/16385/1494810: -1 bytes, 1450
[2005-11-16 11:59:29.015 ] 4904 ERROR:
could not read block 25447 of relation 1663/16385/1494810: I
Our DBAs reviewed the Microsoft documentation you referenced,
modified the registry, and rebooted the OS. We've been beating
up on the database without seeing the error so far. We'll keep at
it for a while.
-Kevin
>>> Qingqing Zhou <[EMAIL PROTECTED]> >>
want to tell Windows users to make highly technical
changes to the Windows registry in order to use PostgreSQL,
it does seem wise to use retries, as has already been discussed
on this thread.
-Kevin
>>> "Magnus Hagander" <[EMAIL PROTECTED]> >>>
[copying this o
I'm not an expert on that, but it seems reasonable to me that the
page pool would free space as the I/O system caught up with
the load. Also, I'm going on what was said by Qingqing and
in one of the pages he referenced:
http://support.microsoft.com/default.aspx?scid=kb;en-us;2743
the machine, so I can no longer check for events
from the failures. :-(
-Kevin
>>> "Magnus Hagander" <[EMAIL PROTECTED]> >>>
> None of this seems material, however. It's pretty clear that
> the problem was exhaustion of the Windows page pool. Our
A couple clarifications:
There were only a few network sockets open.
I'm told that the eventlog was reviewed for any events which
mgiht be related to the failures before it was cleared. They
found none, so that makes it fairly certain there was no 2020
event.
-Kevin
>>> &
eload of the data anyway.
Thanks,
Kevin
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
The Consolidated Court Automation Programs (CCAP) of the Wisconsin Court
System has migrated to PostgreSQL for all of its Circuit Court web
operations. Eight production databases have been converted, six of them
around 180 GB each, holding statewide information replicated real-time
from 72 county
>>> On Tue, Mar 14, 2006 at 2:08 am, in message
<[EMAIL PROTECTED]>, Simon Riggs
<[EMAIL PROTECTED]> wrote:
> On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote:
>> Even more important is the fast response we have had when posting
>> problems to th
.
If you search the lists for it, be sure to take the last patch from the
patches list, there were several iterations to this, and you don't want
the earlier ones.
-Kevin
>>> "sandhya" <[EMAIL PROTECTED]> >>>
Hi
When i am trying to insert a string data
acy of the other
statistics, as well? Would anyone else be interested in something like
this (probably controlled by a configuration option), or are we unique
in this regard?
-Kevin
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, plea
>>> On Mon, Apr 3, 2006 at 11:52 am, in message
<[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> Is there any way to tweak this in favor of more accurate
information,
>> even if has a
mmand would be told to
ignore errors and continue).
Thanks,
Kevin
---(end of broadcast)---
TIP 6: explain analyze is your friend
child table? Or is there a
way for this to be implicitly copied when the child table is created?
I prefer not to change the system default on all the tables in the
database because the value needs to be increased for one case.
Thanks,
Kevin
---(end o
e had experienced something similar / knows what else we can do to
return this disk space back to the system?
Thank you in advance for any/all help!
Kevin
begin:vcard
fn:Kevin Johnson
n:Johnson;Kevin
org:Raytheon AWIPS Team
adr:SMCC II;;;1325 East West Highway;Silver Spring;MD;20910
email;internet:[
, Sep 13, 2006 at 09:53:16 -0400,
Kevin Johnson <[EMAIL PROTECTED]> wrote:
We have a database, which consistently consumes more and more of the
disk space in it's lvol until it reaches 100%. So far, we have tried to
run a full vacuum on the database, with limited success. Eve
ion how often you're vacuuming the table. If you don't vacuum the
table frequently enough, you're going to get bloat, plain and simple.
On Oct 5, 2006, at 11:24 AM, Kevin Johnson wrote:
Thank you for the suggestion, Bruno. The
clustering did the trick in reducing the current disk
lease help me with the trouble shooting procedure.
Regards,
Kevin
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
t postgres 7.3.4 and OS 10.2 which talk about making
readline and using the /sw directory which does not exist on system.
Does anybody know what I am missing?
Thank you in advance for any help
Kevin Barnard
---(end of broadcast)---
TIP 9: the pl
On Feb 16, 2004, at 8:27 PM, Tom Lane wrote:
Jeremy Buchmann <[EMAIL PROTECTED]> writes:
... Readline is available, and this may be the way to go if you
can't get readline to compile on its own.
There isn't anything difficult about installing readline from source
on Panther. Untar, configure, ma
es postgres262144 Apr 21 13:38 000D
-rw---1 postgres postgres 90112 Apr 22 07:01 000E
Thanks
Kevin
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL P
uch
file or directory
I found libgcc_s.so.1 in /usr/local/lib and that directory is in
$LD_LIBRARY_PATH. Is there anything that I'm missing here or that I need to
look for in my configure settings?
Kevin
---(end of broadcast)---
TIP 8: explain analyze is your friend
That would seem to be the problem.
Thanks.
Kevin
- Original Message -
From: "Jim Seymour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 6:26 PM
Subject: Re: [ADMIN] initdb error
> "Kevin Schroeder" <[EMAIL PROTECTED]>
to reduce the shared buffers
size. Plus, with 2GB of RAM I don't know that I'd want to go below the
"lowest common denominator" that Postgres defaults to.
Kevin
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
There we go. For reference, what page did you get that info and what did
you search for to get it?
Kevin
- Original Message -
From: "Jim Seymour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 10:57 AM
Subject: Re: [ADMIN] Shared memory
Searching Google brought up this page.
http://www.postgresql.org/docs/current/interactive/kernel-resources.html
- Original Message -
From: "Jim Seymour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 1:14 PM
Subject: Re: [ADMIN] Shared memory error using initdb
Try re-installing PostgreSQL, dumping it, then re-installing the new
version.
Kevin
- Original Message -
From: "Jón Ragnarsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 12:29 PM
Subject: [ADMIN] Stupid mistake: Forgot to dum
have enabled debugging but all I get on the client side is
bash-2.03$ psql -h ukl** -d test -U kevin
bash-2.03$ DEBUG: InitPostgres
bash-2.03$
And on the serverside I get
Aug 5 17:01:38 uklnx04 postgres[27887]: [222-1] DEBUG: 0: forked new backend, pid=28522 socket=10
Aug 5 17:01:38
Hi Tom,
Thanks for the reply but forgive my ignorance but how do I setup the debugger breakpoint ?
Regards
Kevin Izzet
Database / Unix Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED]
"Tom Lane" <[EMAIL PROTECTED
a3 in PostmasterMain ()
#6 0x08110f56 in main ()
Thanks for your help sofar...
p.s. Installed phpPgAdmin and that appears to work fine, don't know if that makes any difference
Regards
Kevin Izzet
Database / Unix Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 63
= 0
937: sigaction(SIGPIPE, 0xFFBEECC0, 0xFFBEED40) = 0
937: send(4, " X\0\0\004", 5, 0) = 5
937: sigaction(SIGPIPE, 0xFFBEECC0, 0xFFBEED40) = 0
937: close(4) = 0
937: sigaction(SIGPIPE, 0xFFBEEF10, 0xFFBEEF9
rom a Linux Client as a Solaris client may point to something I've configured wrongly..
:-(
Regards
Kevin Izzet
Database / Unix Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED]
"Tom Lane" <[EMAIL PROTE
much..
Regards
Kevin Izzet
Database / Unix Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED]
"Tom Lane" <[EMAIL PROTECTED]>
09/08/2004 16:45
To: "Kevin Izzet" <[EMAIL PROT
Not sure if this will fit the bill
http://www.thekompany.com/products/rekall/
Regards
Kevin Izzet
Database / Unix Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED
Hi,
You could try running the command like this
$psql dbname < sqlfile > /dev/null
I believe this should work fine
Regards
Kevin Izzet
Database / Unix / Linux Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: [EMAIL PROTECTED]
"P
Hi List;
Anyone have any thoughts per which logging method (SYSLOG vs STDERR) is the
better approach ?
Thanks in advance...
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
24:37.490 CDT] 11981 LOG: redo starts at 1D7/D7DC8D8C
[2007-06-18 13:24:37.526 CDT] 11981 LOG: unexpected pageaddr 1D7/C1FE8000 in
log file 471, segment 215, offset 16678912
[2007-06-18 13:24:37.526 CDT] 11981 LOG: redo done at 1D7/D7FE6730
[2007-06-18 13:24:37.895 CDT] 11981 LOG: database system is ready
[2007-06-18 13:24:57.380 CDT] 12034 ERROR:
could not access status of transaction 10
[2007-06-18 13:24:57.380 CDT] 12034 DETAIL:
Could not open file "pg_clog/": No such file or directory.
Could all of this be reasonably explained by the controller failure and/or the
subsequent abrupt power loss, or should I be looking for another cause?
Personally, as I look at this, I'm suspicious that either the controller didn't
persist dirty pages in the June 14th failure or there is some ongoing hardware
problem.
Thoughts or suggestions?
-Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
>>> On Tue, Jun 19, 2007 at 8:07 AM, in message <[EMAIL PROTECTED]>,
Chander Ganesan <[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
>>
>> weekly maintenance process which builds a new version of a table based on
>> records retention rules. It
> the system needs to recycle to a new logfile.
If you need to force a WAL file to test your backup process, try running
something like:
select pg_switch_xlog();
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE
-Kevin
--
Thanks, all. Just an FYI to wrap up the thread.
>>> On Mon, Jun 18, 2007 at 3:25 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> I'm suspicious that either the contro
(PID 13994) exited with exit code 1
>
> LOG: aborting startup due to startup process failure
You're not terminating the warm standby while the database is still logging
"the database system is starting up", are you?
If so, I would wait for a minute until
Simon's email, I went and modified one line of our script.
I'll paste the current form below my "signature". Please let me know
if we're off base.
-Kevin
#! /bin/bash
# Pick out county name from the back of the path.
# The value of $PWD will be: /var/pgsql/data/county//da
>>> On Fri, Jun 29, 2007 at 11:47 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> History files are only created when you do a PITR recovery that stops
> short of the end of WAL (ie, you gave it an explicit stopping point
> criterion). So basically they never appear e
>>> On Fri, Jun 29, 2007 at 12:29 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> Tom Lane <[EMAIL PROTECTED]> wrote:
>>> Offhand I would recommend the same s
instead of COPY statements. That has worked for me.
-Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Sunday 08 July 2007 16:21:42 Ben Kim wrote:
> On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote:
> >I have been asked if it is possible to asynchronously replicate a
> > postgresql database to ms-sql. My answer is yes, provided postgresql
> > ORM features aren't used in the de
>>> On Fri, Jul 27, 2007 at 9:49 AM, in message
<[EMAIL PROTECTED]>, "George Wilk"
<[EMAIL PROTECTED]> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Could you use the first couple lines of
pparently be able to
deal directly with the Linux layer. At that point, there are obvious, clean
solutions; but we've got to have something reasonable until such date, which
is most likely a few years off.
-Kevin
---(end of broadcast)---
TIP
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 1:28 PM >>>
> On Tue, Aug 07, 2007 at 06:29:35AM -0500, Kevin Grittner wrote:
>> We have a database in each Wisconsin county which is part of the official
>> court record for the circuit courts in that count
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 4:51 PM >>>
> On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote:
> > > Copying a 16MB file that's already in memory isn't exactly an intensive
> > > operation...
> >
> &
>>> On Tue, Aug 7, 2007 at 10:31 PM, in message
<[EMAIL PROTECTED]>, Andrew Kroeger
<[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
>> The Netware server supports ssh, scp, and an rsync daemon. I don't see how
>> the ssh implementation is helpf
>>> On Thu, Aug 9, 2007 at 4:37 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
> I have, by default, on a linux machine, a file called
> serverlog in the data directory, whose entries often
> prove to be very useful. What would be even more useful
> would be a timest
after you include the PostgreSQL .h files:
PG_MODULE_MAGIC;
I was unable to quote the actual error in my reply.
Try a different way to show it next time, please.
-Kevin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| Multicolored| t| DIC
PNK | Pink| t| PNK
XXX | Unknown | t| UNK
(7 rows)
-Kevin
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
>>> On Mon, Aug 13, 2007 at 1:13 PM, in message
<[EMAIL PROTECTED]>, Steve Holdoway
<[EMAIL PROTECTED]> wrote:
> On Mon, 13 Aug 2007 13:07:43 -0500
> "Kevin Grittner" <[EMAIL PROTECTED]> wrote:
>> This gets me all the eye color codes that don
ore the sets in temporary tables to get there without
generating from scratch each time, if that is expensive.
-Kevin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
o get the source code
> of postgreSQL.
Did you try adding -r REL7_1 to the checkout command?
I sure hope this is for some academic purpose and not for production use
-Kevin
---(end of broadcast)---
TIP 4: Have you searched
guarantee that you'd get the same results in two different runs.
-Kevin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
e some of the default rights of the public group.)
If you can't get it to work as desired, please post again with more
specifics.
-Kevin
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
1 - 100 of 1038 matches
Mail list logo
