Jun 14, 2010 at 10:57, Scott Marlowe wrote:
>> On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander wrote:
>>> On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote:
>>>> Apparently the problem boils down to this question: how did some of the
>>>> files get set to
. It does not therefore
seem 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 relat
>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
inten
I have information
We had noticed two relations, their numbers being 16384/16642 and 16384/16792.
Here is what pg_class has for them.
"relname";"relnamespace";"reltype";"relowner";"relam";"relfilenode";"reltablespace";"relpages";"reltuples";"reltoastrelid";"reltoastidxid";"relhasindex";"relissh
ccess to the new computer 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:
>
>
plication.
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
>>>
&g
in development
mode now: it was loaded with data 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
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 apol
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 compu
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 migh
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 th
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
mult
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),
ysical backup 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 re
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
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
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
ump.
Also, 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
t
it's my 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:
&
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,
20 matches
Mail list logo
