, Scott Marlowe scott.marl...@gmail.com wrote:
On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Jun 14, 2010 at 05:17, John T. Dow j...@johntdow.com wrote:
Apparently the problem boils down to this question: how did some of the
files get set to be system
I have information
We had noticed two relations, their numbers being 16384/16642 and 16384/16792.
Here is what pg_class has for them.
can you please give more information about the (windows)-user postgres ?
is it a local user on that machine? How was that user created?
It's the user created by the one-click installer. I believe it owns the
postgres data directory and is used to start the server. Other than that, the
to be related to AV software (the original suggestion) or the OS.
John
On Sun, 13 Jun 2010 14:10:27 -0700, Adrian Klaver wrote:
On Sunday 13 June 2010 1:41:01 pm John T. Dow wrote:
I have information
We had noticed two relations, their numbers being 16384/16642 and
16384/16792.
Here is what
.
John
On Tue, 08 Jun 2010 08:37:02 -0400, John T. Dow wrote:
On Tue, 08 Jun 2010 10:25:49 +0800, Craig Ringer wrote:
On 8/06/2010 9:11 AM, John T. Dow wrote:
OP here
We removed AVG from the computer and rebooted.
Same problem.
OK, good to know. Thanks very much for testing that, and my
where the server
is running. I have no access to the files themselves unless he's there and
let's me in.
Thanks. Keep tuned.
John
On Sat, 12 Jun 2010 15:59:06 -0700, Adrian Klaver wrote:
On Saturday 12 June 2010 12:59:18 pm John T. Dow wrote:
I am CC'ing the list so more eyes can follow
from the legacy system extracted a few months
ago and since then there has been additional data entered and changed as people
have played with and tested the application.
Is this a random event? A bug? Advice please on what to do next.
John
On Tue, 08 Jun 2010 08:37:02 -0400, John T. Dow wrote
On Tue, 08 Jun 2010 10:25:49 +0800, Craig Ringer wrote:
On 8/06/2010 9:11 AM, John T. Dow wrote:
OP here
We removed AVG from the computer and rebooted.
Same problem.
OK, good to know. Thanks very much for testing that, and my apologies
for recommending something that didn't work out
OP here
We removed AVG from the computer and rebooted.
Same problem.
We are quite certain that AVG is no longer installed. It doesn't show up where
it used to, and a search of the registry for AVG finds a couple leftovers but
doesn't seem to indicate that it's still installed.
The
One of my clients is getting this problem occasionally. Actually, we can cause
it to happen quite reliably by pasting certain text into a couple of fields,
but the vast majority of text entered into the vast majority of fields causes
no problem.
I've read enough to suggest that AV software
On Sun, 10 Jan 2010 16:01:57 +0800, Craig Ringer wrote:
On 6/01/2010 10:53 PM, John T. Dow wrote:
I posted this several days ago to pgsql-jdbc but have had no response. I am
posting it here (with minor changes in the wording).
I have developed some code that works, I'm just not sure I have
I posted this several days ago to pgsql-jdbc but have had no response. I am
posting it here (with minor changes in the wording).
I have developed some code that works, I'm just not sure I have the best
solution.
I have applications in which the user can create a read-only resultset with
BACKGROUND INFO BEGINS
Recently I had some questions about doing backups and received very helpful
replies. I have now put together a BAT file to do a routine backup, using
pg_dumpall with the -g option to get the roles, and pg_dump with the custom
format to get all the data.
I am now testing
of the actual database files.
John
On Thu, 28 Aug 2008 11:21:24 -0400, Douglas McNaught wrote:
On Thu, Aug 28, 2008 at 10:57 AM, John T. Dow [EMAIL PROTECTED] wrote:
BACKGROUND INFO BEGINS
Recently I had some questions about doing backups and received very helpful
replies. I have now put together
I understand that WAL files can only be used with the database files in use at
the time the WAL was written, therefore they are of no use to a database
reconstructed from a pg_dump file.
Let me see if I have this right.
A - To protect against temporary server failure (such as a loss of power),
By bad data, I mean a character that's not UTF8, such as hex 98.
As far as I can tell, pg_dump is the tool to use. But it has
serious drawbacks.
If you dump in the custom format, the data is compressed (nice) and
includes large objects (very nice). But, from my tests and the postings of
others,
understanding that the binary data is output in an inefficient format
so even if zipped, the resulting file would be significantly larger than the
custom format.
On Mon, 25 Aug 2008 12:14:41 -0400, Tom Lane wrote:
John T. Dow [EMAIL PROTECTED] writes:
If you dump in plain text format, you can
, I stumbled across the statement that you can't restore large objects for
a single table. Is that true?
Another thing I couldn't find was how to dump roles using -Fc.
John
On Mon, 25 Aug 2008 10:04:13 -0700, Joshua Drake wrote:
On Mon, 25 Aug 2008 10:21:54 -0400
John T. Dow [EMAIL PROTECTED
information there to reconstruct the roles should that become necessary.
Can pg_dump dump roles to plain text? How does pg_dumpall do it, doesn't it do
everything via pg_dump?
John
On Mon, 25 Aug 2008 10:47:11 -0700, Joshua Drake wrote:
On Mon, 25 Aug 2008 13:37:13 -0400
John T. Dow [EMAIL
Sorry, I missed that. Thanks again.
Now to put this all into effect.
John
On Mon, 25 Aug 2008 14:25:12 -0700, Joshua Drake wrote:
On Mon, 25 Aug 2008 17:05:53 -0400
John T. Dow [EMAIL PROTECTED] wrote:
Joshua
Thank you very much for answering these various questions.
I guess
20 matches
Mail list logo