> It's far easier to adjust the logging.
>
> psql mydb
> alter mydb set log_statement='mod';
Thanks Scott.
Two questions:
1. Will this log_statement='mod' be a permanent thing, or when I have
done my testing and identifying the problem SQL, I can set it back to
default so not too much logging
I am not anti-DotNet.. i wanted to make sure everyone understands the pitfalls
one encounters when writing code for a OS and .Net-version specific framework
specifically:
1)change OS - code doesnt work
2)change supported .NET framework version - code doesnt work
if you're writing missile-guid
Hello everyone,
I'm new here, but I have a problem and couldn't find a solution so I
hope you will help me.
I'm trying to reproduce the pg_statistics catalog from one database
server to another one. To retrieve the data from the first server was a
trivial job. The trouble was when I tryied to ins
Here [->
http://old.nabble.com/-GENERAL--Access-to-databas-from-the-Internet-td6388294.html#a6388294
http://old.nabble.com/-GENERAL--Access-to-databas-from-the-Internet-td6388294.html#a6388294
] there is a very similar thread, I feel sorry for the redundancy.
Anyway I would ask to you some more
Hi to everyone,
well until now I could easiily access a remote hosted database in my local
network via PgAdmin: just set the IP and port and login info and I was done.
But whether I want to access that database from outside my network, even
without encrypted tunnels by now, what do I have to do?
Teodor Macicas writes:
> I'm trying to reproduce the pg_statistics catalog from one database
> server to another one.
You can't really, and manually fooling with system catalogs is usually
a bad idea anyway. Just run ANALYZE.
regards, tom lane
--
Sent via pgsql-general
Thank you for your reply, Tom.
Why I can't ? And for my purpose is not a bad idea. I mean, I have to do
this and somehow I should find a solution.
In order to use ANALYZE I need the same data on 2nd machine, but the
data is quite large and the only information I need are the statistics
from p
Teodor Macicas writes:
> Why I can't ? And for my purpose is not a bad idea. I mean, I have to do
> this and somehow I should find a solution.
> In order to use ANALYZE I need the same data on 2nd machine, but the
> data is quite large and the only information I need are the statistics
> from
Hi Tom,
Thank you again for your quick reply.
Shall we pass the reason for I want to do this ? I can explain, but it's
a long story. The idea is that *for sure* I need those metadata there. I
want to use them on the second machine.
Regards,
Tedy
Tom Lane wrote:
Teodor Macicas writes:
Wh
On Sat, Jun 19, 2010 at 5:28 AM, Phoenix Kiula wrote:
>> It's far easier to adjust the logging.
>>
>> psql mydb
>> alter mydb set log_statement='mod';
>
>
>
> Thanks Scott.
>
> Two questions:
>
> 1. Will this log_statement='mod' be a permanent thing, or when I have
> done my testing and identifyin
I happened across (yet) another open source project which supports
MySql and Derby (its a Java app) and is thinking about supporting
Oracle (they have actually bought a licence) but does not support
Postgresql. This particular project is onehippo.org, but there are many
others. Another perhaps m
On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote:
> These projects need help to realise that adding Postgresql is not a
> big
> job, especially for those using JDBC which can already connect to all
> DBs. It strikes me that if the project could write a few pages
> gleaned
> from other por
I am using a PHP client. Is there a way to do the above task with php?
On Thu, Jun 17, 2010 at 11:38 PM, Francisco Figueiredo Jr. <
franci...@npgsql.org> wrote:
> I would go with 2).
>
> Npgsql supports multiple resultsets. You can pass a query separated by
> semicolon ';' or you can use a proce
13 matches
Mail list logo
