Greg Steffensen wrote:
I'd like to construct a view containing the usernames, passwords, etc
in jabber's required format, but system catalog information doesn't
seem to be accessible to views.
That is not correct.
---(end of broadcast)---
TIP
I'd like to alter all columns from type varchar to text. Could I do this by:
UPDATE pg_attribute SET atttypid = 25, atttypmod=-1 where attrelid
=(select oid from pg_class where relname='table_name') and atttypid=1043;
I just tried on a test database. It worked fine with one exception:
Views
Hi All,
I desperately need to set up a real time replication of several
databases (for failover) between two servers. Last time I looked at the
PG replication it wasn't yet production level. I wonder if anyone on
this list is doing this successfully and if you won't mind sharing your
Hi All,
Ihave a query.
What is the maximum number of tables I can have in
a PGSql Database, without affecting performance?
Thanks in advance.
Regards,
Ashvinder
Hi,
In my application I need to useold database present on postgersql
at client site. For that I have created dump using
pg_dump -o db_name | gzip
db_dump
command at the client site and then downloaded the dump on local
server. But when I am trying to restore, it only restore the empty
Hi,
I am trying to take Database backup. I use this
command.
# ./pg_dump -U username -cif filename.sql dbname
Its exporting, but in the Log, its giving like
LOG: out of file descriptors: Too many open files;
release and retry
Can anybody tell me what is this? And what i have to
do clear this
Hello!
Would it be possible to have an option log_min_cost_statement, similar to
log_min_duration_statement except that it logs all statement that has
an minimum cost estimated by the planner? I think it would be easier to
find unoptimized queries that way.
Just a thought!
/Nichlas
On Tue, 13 Apr 2004, Stefan Holzheu wrote:
I'd like to alter all columns from type varchar to text. Could I do this by:
UPDATE pg_attribute SET atttypid = 25, atttypmod=-1 where attrelid
=(select oid from pg_class where relname='table_name') and atttypid=1043;
I just tried on a test
JinNet Picker wrote:
Hi,
I am trying to take Database backup. I use this
command.
# ./pg_dump -U username -cif filename.sql dbname
Its exporting, but in the Log, its giving like
LOG: out of file descriptors: Too many open files;
release and retry
Can anybody tell me what is this? And what i
JinNet Picker [EMAIL PROTECTED] writes:
LOG: out of file descriptors: Too many open files;
release and retry
Can anybody tell me what is this? And what i have to
do clear this out??
You need to either increase your kernel's limit on the number of
simultaneously open files, or reduce
Nichlas Löfdahl wrote:
Hello!
Would it be possible to have an option log_min_cost_statement, similar to
log_min_duration_statement except that it logs all statement that has
an minimum cost estimated by the planner? I think it would be easier to
find unoptimized queries that way.
Uh, yea,
Nichlas Löfdahl wrote:
Would it be possible to have an option log_min_cost_statement,
similar to log_min_duration_statement except that it logs all
statement that has an minimum cost estimated by the planner? I think
it would be easier to find unoptimized queries that way.
If you believe that
Nichlas =?iso-8859-1?Q?L=F6fdahl?= [EMAIL PROTECTED] writes:
Would it be possible to have an option log_min_cost_statement, similar to
log_min_duration_statement except that it logs all statement that has
an minimum cost estimated by the planner? I think it would be easier to
find unoptimized
Bradley Kieser wrote:
I desperately need to set up a real time replication of several
databases (for failover) between two servers. Last time I looked at
the PG replication it wasn't yet production level. I wonder if anyone
on this list is doing this successfully and if you won't mind sharing
I am trying to build Postgres 7.4.2 from the source rpm on Red Hat Linux 7.1
2.96-98
I get the following error message:
[EMAIL PROTECTED] usr]# rpmbuild --rebuild postgresql-7.4.2-1PGDG.src.rpm
Installing postgresql-7.4.2-1PGDG.src.rpm
error: failed build dependencies:
tcl-devel is needed
Donald Fraser [EMAIL PROTECTED] writes:
I am trying to build Postgres 7.4.2 from the source rpm on Red Hat Linux 7.1
2.96-98
error: failed build dependencies:
tcl-devel is needed by postgresql-7.4.2-1PGDG
This dependency is bogus; it doesn't apply to RHL 7.1. The easiest
solution is
- Original Message -
I am trying to build Postgres 7.4.2 from the source rpm on Red Hat Linux
7.1
2.96-98
error: failed build dependencies:
tcl-devel is needed by postgresql-7.4.2-1PGDG
This dependency is bogus; it doesn't apply to RHL 7.1. The easiest
solution is to
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Peter Eisentraut) wrote:
Bradley Kieser wrote:
I desperately need to set up a real time replication of several
databases (for failover) between two servers. Last time I looked at
the PG replication it wasn't yet production level. I
Donald Fraser [EMAIL PROTECTED] writes:
Thanks - that got things going for me.
Unfortunately it fails to complete the configure script due to the following
messages
[ python problems... ]
Hm, python is outside my sphere of expertise :-(
You're asking on quite the wrong list though. Try
19 matches
Mail list logo