Hi John. Thanks a lot for your reply:
El día 1 de marzo de 2012 17:25, John R Pierce escribió:
> On 03/01/12 9:02 AM, Ruben Blanco wrote:
> specify host=localhost, otherwise its using the first 'local' line, which
> specifies 'ident' authentication, as the error imp
Hi:
I cannot connect to my Postgres database from my PHP scripts. I get the error:
PHP Warning: pg_connect(): Unable to connect to PostgreSQL server:
FATAL: Ident authentication failed for user "postgres" in ...
I have tried many combinations for "host" TYPE in "pg_hba.conf"
(restarting po
ate))
Filter: (outgoing_call <> 'I'::bpchar)
Total runtime: 656.103 ms
Size of the index used:
SELECT pg_size_pretty(pg_total_relation_size('calls_201109_index_2'));
pg_size_pretty
330 MB
Hi:
After partitioning a big table, I am getting slower performance on queries
run on the non-partitioned table (llamadas) than the partitioned table
(llamadas_maestra).
Not partitioned table:
heos_prod=# explain analyze select * from llamadas where cod_empresa=1
and fecha_llamada='2011062
Hi:
Is there anyway to create a unique index or constraint on part of a column?
Something like this, but something that works ;-)
ALTER TABLE invoices
ADD CONSTRAINT cons UNIQUE (EXTRACT(YEAR FROM invoice_date),
innvoice_number);
Thanks for any help.
Ruben,
Thanks a lot, guys. There were two users running Navicat, and these killer
queries are indeed run by this program.
Rubén.
2011/2/13 John R Pierce
> On 02/12/11 5:11 PM, Ruben Blanco wrote:
>
>> Hi:
>>
>> I'm running a Postgres database with a total disk occupation
ncel_backend" to recover database
functionality.
So, what are these queries indeed? Is it advisable to cancel them? Is there
any way to prevent these situation to happen?
I use PostgreSQL 8.4.4 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit.
Thanks in advance for any help.
Ruben.
storage while the primary server is running.
For these resons is posible to use a SAN?
Regards.
- "Craig Ringer" escribió:
> On 9/09/2010 10:27 AM, Lazaro Ruben Garcia Martinez wrote:
> > Hello everyone:
> >
> > I am a student of the University of Informati
Hello everyone:
I am a student of the University of Informatics Science in Cuba. I want create
a postgresql cluster and I have two servers but I have a doubt. Is possible to
create a cluster of postgresql server by sharing the database file on a SAN?
Regards.
Thank you very much for your tim
Hello:
I have two servers and I want create a database cluster in a SAN (storage area
network), can any send my any link or any web site in that I can read and study
about it.
Thank you very much for your time.
Hello everyone, I have a doubt:
A null value in a field could affect the performance of the database??
Regards.
Thank you very much for your time.
- "Digimer" escribió:
> On 10-08-16 09:51 PM, Lazaro Ruben Garcia Martinez wrote:
> > Hola a todos, desde hace mucho t
Hola a todos, desde hace mucho tiempo tengo una una duda relacionada con los
campos nullos, quería saber si tanto el empleo como la presencia de los mismos
ya sea en tablas pequeñas o grandes, pude afectar de alguna forma el
rendimiento del sistema, ademas quisiera saber que inconvenientes puede
Hi:
My database is growing fast taking too much disk space. How can I free disk
space without performing a VACCUM FULL? It locks the database for several
hours, and that is not a solution.
I guess a backup-restore would do the work but, isn't there a better way to
do this without shutting down po
Since there is no current solution to ranking values in pl/pgsql as the
rank() over (partition by... that there is in oracle i am hoping someone
can help me out here.
The table i created contains the following columns:
rank | value
I wrote a cursor that will give me all the values.
Does postgreSQL have an equivalent of the Oracle's "rank() over by
partition"?
Here's what i have so far but it doesn't work:
select id,
sum(case when key = 5 then 1 else 0 end),
sum(case when key = 6 then 1 when key = 7 then 1 else 0 end),
sum(case when l.status = 6 then cos
Hello List.
I need to make finding precise words or phrases in Word documents (I put
this document as plain text to a field text type of a table in my database).
I'm working with PostgreSQL 8.3.1 on Linux; before, working with tsearch2-in
version 8.2.x-could find presence or absence of a word in t
Thanks Martijn:
Martijn van Oosterhout wrote:
On Wed, Sep 28, 2005 at 11:40:11AM +0200, ruben wrote:
Hi Tom:
No way to get the core dump, this is what I did:
1) Add "ulimit" to /etc/rc.d/init.d/postgresql just before pg_ctl start
in the "start" section of the scri
that produces the crash.
4) Search core file:
-bash-2.05b$ find /usr/local/pgsql/ -name '*core*' -print
-bash-2.05b$
Nothing comes up.
Thanks for your help.
Ruben.
Tom Lane wrote:
ruben <[EMAIL PROTECTED]> writes:
As I recall, released versions of Post
Thanks Tom and Michael:
Michael Fuhr wrote:
On Fri, Sep 23, 2005 at 05:11:19PM +0200, ruben wrote:
The operating system is Red Hat Linux release 8.0 (Psyche) and
PostgreSQL version is 7.4.6., without non-standard extensions.
I cannot find any core dump in the PGDATA directory /usr/local
Hi:
A PHP script that is running every 30 minutes for three years has
crashed when updating a Postgres database table with this error message:
"pg_exec() query failed: could not send data to server: Operation not
supported"
I just ran it again and it worked fine. I could not find a single
Hi Michael:
The operating system is Red Hat Linux release 8.0 (Psyche) and
PostgreSQL version is 7.4.6., without non-standard extensions.
I cannot find any core dump in the PGDATA directory /usr/local/pgsql (I
don't know how to debug it to get a stack trace, I'll find out).
Tha
system is ready
This happens every day consistently. The table is quite big, about 1
million tuples and it is vacuumed.
Any help would be appreciated.
Cheers, Ruben.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
an simple select would make it clear
that the aplication that uses
the DB was already doing the INSERT, shame on me :(
Thanks for everything :)
Ruben Oliveira
Richard Huxton wrote:
Ruben Oliveira wrote:
I'm having an unexpected behavior from an UPDATE query :
I expected only updates to exist
6,3) | not null default 0.000
field7 | text | not null default ''::text
Indexes:
"table084_pkey" PRIMARY KEY, btree (field1, field2)
Am I missing something ?
I can give you more details if needed.
Thanks for any help ...
Ruben Oliveira
---(e
some other machine the
initdb --locale=C
just to be safe ...
Thanks again ,
Ruben Oliveira
-
Tom Lane wrote:
Ruben Oliveira <[EMAIL PROTECTED]> writes:
Can anybody tell me if there is something I can do in the Linux config
to have the same order by result ??
Sort order is determine
Hello everybody !
I have this order by :
select lalala from tablex order by field_y;
where field_y is a text column.
that returns something like :
2.1004.11
21.00.461
2.1006.21
in PostgreSQL 7.3.2 in Linux Mandrake 9.1
but in PostgreSQL 8.0.0 in Windows XP it works as I expected ...
2.1004.11
2.10
Hi:
No way to access "tablename". Can I do something to recover? Is this a
hardware error?
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
Thanks in advance.
Ruben.
---(end of
Hi:
I'm trying to dump tableA and restore it to tableB:
$ ./pg_dump -Fc -t tableA databaseA -f tableA.dump -v
$ ./pg_restore -t tableB -d databaseA tableA.dump -v
pg_dump creates tableA.dump aparently well, but after running pg_restore
without errors I cannot find any "tableB", what am I doing wro
Thanks Martijn:
It worked. I was having issues with 7.4.2, run memory ans disk checks
and hardware seems ok, that's why I decided to upgrade to 7.4.5, but
unfortunately I'm still experiencing data corruption.
Ruben.
ruben20 wrote:
-- Forwarded Message ---
From: M
Hi Gaetano:
This procedure to recover data from a corrupted table should be
documented somewhere... If it is, I could not find it!
Now I wonder if I have lost any data, because after creating the
pg_clog/0004 and running VACCUM everything seems ok.
Thanks a lot for your help.
Ruben.
Gaetano
Hi:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block"
Half th
Thanks Harald, i'm running PostgreSQL 7.1.3.
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
ruben <[EMAIL PROTECTED]> writes:
Today, one of the processes running daily took 4 hours when it takes
about 5 minutes. After a VACCUM ANALYZE of the affected tables it took
the sam
Hi:
I'm running a large database on PostgreSQL 7.1.3. 20 days ago the
database failed with a threatening and not too descriptive error like:
pg_exec() query failed: server closed the connection unexpectedlyThis
probably means the server terminated abnormally before or while
processing the
table "afected_table"
failed: PQendcopy() failed.
pg_dump: Error message from server: FATAL 1: The database system is
starting up
Ruben.
mike g wrote:
Can you use pg_dump to backup the database and possibly then upgrade the
db? 7.2 is rather old. I recall reading similar postings in the
ma
7)"
Any help on how to recover the table would be greatly appreciated.
Thanks, Ruben.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
0030808'
;
NOTICE: QUERY PLAN:
Nested Loop (cost=0.00..317.07 rows=3 width=351)
-> Seq Scan on table_b (cost=0.00..308.80 rows=1 width=124)
-> Index Scan using table_a_i01 on table_a (cost=0.00..8.24 rows=2
width=227)
EXPLAIN
Index on table_a is defined
Hi Martijn:
Thanks for your answer, I really missed something ;-)
Kind regards, Ruben.
Martijn van Oosterhout wrote:
On Mon, Aug 11, 2003 at 01:48:21PM +0200, ruben wrote:
Hi:
I must have missed something, but how is it possible that a join on
tables A and B is faster (a lot faster) than
37 matches
Mail list logo
