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 dep
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
experienc
Hi All,
I have 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 use old 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
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 thi
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 h
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 P
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.
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 belie
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 uno
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 shari
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
solu
- 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
> sol
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 le
"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. T
18 matches
Mail list logo