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 is
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
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
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 teodor.maci...@epfl.ch 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
--
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
Teodor Macicas teodor.maci...@epfl.ch 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
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
On Sat, Jun 19, 2010 at 5:28 AM, Phoenix Kiula phoenix.ki...@gmail.com 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
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
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 porting
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 procedure
13 matches
Mail list logo