Hi,
Thanks for the feedback.
Log:
LOG: connection authorized: user=postgres database=template1
LOG: statement: select pg_start_backup('bkpfull',true);
ERROR: a backup is already in progress
HINT: Run pg_stop_backup() and try again.
STATEMENT: select pg_start_backup('bkpfull',true);
LOG: di
Hello Robert,
Thanks for the feedback.
The my script works, but after a few days it stops working because the
process does not end pg_stop_backup.
The pg_basebackup already does this substitution?
--
View this message in context:
http://postgresql.nabble.com/Pg-stop-backup-process-does-not-r
Hi,
On alternate days my backup is failing, by the pg_stop_backup process ()
does not perform or quit.
Version PostgreSQL: 9.1.6
The following backup script:
PGDATA=/dados
SAVE_BASE_DIR=/backup/diario
backup="'bkpfull'"
data=$(date +'%d%m%y')
WAL_DIR=/backup/archive
mv $WAL_DIR/* $WAL_DIR/wal
2015-11-30 0:39 GMT-02:00 Tom Lane:
> Rodrigo Hjort writes:
> > I created a custom C function with this signature:
>
> > CREATE FUNCTION calculate_hash(numbers int2[])
> > RETURNS int8
> > AS 'MODULE_PATHNAME', 'pg_calculate_hash'
> >
The whole project is on GitHub:
https://github.com/hjort/mega-sena/tree/master/src
Best regards,
--
Rodrigo Hjort
www.hjort.co
The whole project is on GitHub:
https://github.com/hjort/mega-sena/tree/master/src
Best regards,
--
Rodrigo Hjort
www.hjort.co
#x27; comment marker in the file's entry.
Or you changed the wrong postgresql.conf file
Regards
Rodrigo Gonzalez
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
than today cause of my lack of source code..
Best regards
Rodrigo Gonzalez
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
...we should smart enough to use the power we receive...if
we are not smart...we should start thinking about other profession
And excuse my English, I hope the point is clear...
Best regards
Rodrigo Gonzalez
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make change
On Wed, 26 Jun 2013 14:13:32 -0400
Bruce Momjian wrote:
> On Wed, Jun 26, 2013 at 03:12:00PM -0300, Rodrigo Gonzalez wrote:
> > On Wed, 26 Jun 2013 09:14:07 -0400
> > Bruce Momjian wrote:
> >
> > > On Wed, Jun 26, 2013 at 10:40:17AM +1000, Brendan Jurd wrote:
On Wed, 26 Jun 2013 09:14:07 -0400
Bruce Momjian wrote:
> On Wed, Jun 26, 2013 at 10:40:17AM +1000, Brendan Jurd wrote:
> > On 26 June 2013 03:17, Josh Berkus wrote:
> > > How should reviewers get credited in the release notes?
> > >
> > > a) not at all
> > > b) in a single block titled "Reviewe
On Fri, 07 Jun 2013 13:07:21 -0700
"Joshua D. Drake" wrote:
>
> On 06/07/2013 12:31 PM, Tom Lane wrote:
> > "Joshua D. Drake" writes:
> >> On 06/07/2013 11:57 AM, Tom Lane wrote:
> >>> I think it's intentional that we don't tell the *client* that
> >>> level of detail.
> >
> >> Why? That seems
On Mon, Apr 15, 2013 at 7:51 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > I created a implic cast for mytype to bigint.
> > So when I do the same query it does seq scan, because the column is
> > transformed into bigint.
>
> Yeah. One reason why there's not
On Mon, Apr 15, 2013 at 5:33 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > I created a type 'mytype' (an unsigned int) and created an operator class
> > for index.
> > Then I created a table with a column of my type and isnerted 1000
> entries.
> >
Hi guys.
I created a type 'mytype' (an unsigned int) and created an operator class
for index.
Then I created a table with a column of my type and isnerted 1000 entries.
But no matter how many entries I have in the table, it never uses the
index. It always does a seq scan.
Here is the explain analy
On Wed, Apr 10, 2013 at 12:24 AM, Amit Kapila wrote:
>
> On Tuesday, April 09, 2013 6:19 PM Rodrigo Barboza wrote:
> On Tue, Apr 9, 2013 at 3:05 AM, Amit Kapila
> wrote:
> On Monday, April 08, 2013 7:28 PM Rodrigo Barboza wrote:
> >> You have identified rightly in your ot
On Tue, Apr 9, 2013 at 3:05 AM, Amit Kapila wrote:
> On Monday, April 08, 2013 7:28 PM Rodrigo Barboza wrote:
> On Sat, Apr 6, 2013 at 10:39 PM, Rodrigo Barboza
> wrote:
> Ok! I will try to reproduce in a smaller scenario.
> On Sat, Apr 6, 2013 at 9:53 PM, Amit Kapila
> wr
On Mon, Apr 8, 2013 at 4:30 PM, Rodrigo Barboza wrote:
>
>
>
>
> On Mon, Apr 8, 2013 at 12:14 PM, Rodrigo Barboza
> wrote:
>
>>
>>
>>
>> On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza > > wrote:
>>
>>>
>>>
>>>
On Mon, Apr 8, 2013 at 12:14 PM, Rodrigo Barboza wrote:
>
>
>
> On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza
> wrote:
>
>>
>>
>>
>> On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza > > wrote:
>>
>>>
>>>
>>> O
On Mon, Apr 8, 2013 at 11:44 AM, Rodrigo Barboza wrote:
>
>
>
> On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza
> wrote:
>
>>
>>
>> On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
>>
>>> Rodrigo Barboza writes:
>>> > UPDATE
On Mon, Apr 8, 2013 at 11:27 AM, Rodrigo Barboza wrote:
>
>
> On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
>
>> Rodrigo Barboza writes:
>> > UPDATE tm32 SET a = a + 1 WHERE a > $i;
>> > ERROR: unsupported type: 202886
>>
>> I'm be
On Mon, Apr 8, 2013 at 11:25 AM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > UPDATE tm32 SET a = a + 1 WHERE a > $i;
> > ERROR: unsupported type: 202886
>
> I'm betting that's coming from scalargtsel, which doesn't know anything
> about your type, but
Ok! I will try to reproduce in a smaller scenario.
On Sat, Apr 6, 2013 at 9:53 PM, Amit Kapila wrote:
> On Saturday, April 06, 2013 12:18 PM Rodrigo Barboza wrote:
> >On Sat, Apr 6, 2013 at 12:23 AM, Amit Kapila
> wrote:
> >> On Saturday, April 06, 2013 3:57 AM
On Sat, Apr 6, 2013 at 12:23 AM, Amit Kapila wrote:
> > On Saturday, April 06, 2013 3:57 AM Rodrigo Barboza wrote:
>
> >Hello.
> > I created a type my_uint that is a unsigned int 32.
>
> > I am trying to update data of a table that contains a column of this
&g
Hello.
I created a type my_uint that is a unsigned int 32.
I am trying to update data of a table that contains a column of this type.
Here is what happens:
postgresql=> explain analyze UPDATE attribute_type_conf SET rowform =
rowform +1 where rowform <= 18;
ERROR: unsupported type: 132852
postg
ssing something
On Fri, Apr 5, 2013 at 1:12 AM, Amit Kapila wrote:
> On Thursday, April 04, 2013 8:30 PM Rodrigo Barboza wrote:
>
> > Hi guys.
> > I am wondering when I can use the PG_GETARG_UINT32 and PG_RETURN_UINT32.
> > If postgres has no unsigned int type, what i
Hi guys.
I am wondering when I can use the PG_GETARG_UINT32 and PG_RETURN_UINT32.
If postgres has no unsigned int type, what is the use of these macros?
I see, that's true.
I'm returning unknown type, there is a little more overhead. But it's
working now. =]
Thanks for the help guys!
On Wed, Apr 3, 2013 at 6:17 PM, Robert Haas wrote:
> On Wed, Apr 3, 2013 at 3:25 PM, Rodrigo Barboza
> wrote:
> > Well, I was chec
Well, I was checking inside my function the type of the second argument and
switching between the allowed types.
This way kind of does the same thing of many functions, doesn't it?
On Wed, Apr 3, 2013 at 3:39 PM, Tom Lane wrote:
> Rodrigo Barboza writes:
> > Why not useful?
Why not useful?
If I don't make it receive anyelement, I will have to create an add
function for each type.
Correct me if I'm wrong.
On Wed, Apr 3, 2013 at 2:27 PM, Robert Haas wrote:
> On Wed, Apr 3, 2013 at 11:26 AM, Rodrigo Barboza
> wrote:
> > Hello.
> > I'
Hello.
I'm trying to create a generic add function.
I have defined a type my_uint and it needs a '+' operator.
This operator should work like normal int + int operation.
The function is defined expecting arguments (my_uint, anyelement).
I'm confused in retrieving the anyelement type, value and tha
//git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e3e3087d8717c26cd1c4581ba29274ac214eb816
>
>regards, tom lane
>
I modified my code by calling *palloc0()* instead and that issue no longer
appears. :D
Thanks, Tom Lane!
--
Rodrigo Hjort
www.hjort.co
the same.
1) Do you have any clue on what could be happening and how to solve this
issue, please?
2) Sometimes the value returned by *to_tsquery()* has a ":*" suffix. What
does that mean?
Thanks in advance.
Best Regards,
--
Rodrigo Hjort
www.hjort.co
On 09/13/2011 04:52 PM, Tom Lane wrote:
Rodrigo Gonzalez writes:
In a perfect world, it would be nice if one could do combined queries
linking a PostgreSQL database with an Oracle one, or a MySQL one,
Can't you do that with FDW that is present in 9.1?
FDW provides the structure within
On 09/13/2011 03:51 PM, Michael Nolan wrote:
For example:
A fully integrated ability to query across multiple
databases,possibly
on multiple servers, something Oracle has had for nearly two
decades.
That isn't the approach to take. The fact that Oracle has
On Sun, May 10, 2009 at 12:23 AM, Robert Treat
wrote:
> On Saturday 09 May 2009 00:20:43 Jaime Casanova wrote:
>> On Fri, May 8, 2009 at 3:43 AM, higepon wrote:
>> > Hi.
>> > Is the following todo item still necessary?
>> >
>> > Create dump tool for write-ahead logs for use in determining
>> > t
On Feb 3, 2008 7:41 PM, Jaime Casanova <[EMAIL PROTECTED]> wrote:
> On Feb 3, 2008 7:26 PM, Omar Bettin <[EMAIL PROTECTED]> wrote:
> > Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
> > I know about standards...
> >
>
> NULL means unknown value, ZERO is a known value
()')
rot-> AS (usr name, db name);
usr| db
--+
postgres | escola
(1 registro)
This way, I fear DBLink functions should become a vulnerability issue on my
database.
Is there any way to protect or override this setting? Or it should be done
on pg_hba.conf only
Dear Hackers,
Could you point me the first version PostgreSQL started to support
Deferred Constraints (ie: DEFERRABLE keyword on foreign keys
creation)? I guess it is earlier than 7.0, right?
--
Regards,
Rodrigo Hjort
http://icewall.org/~hjort
---(end of broadcast
>but I'll bet
>a nickel your CREATE TYPE says something else --- probably varlena
You win, how can I pay this bet? :)
Very very thanks, I was looking for the error in the wrong place! It was
so simple and works!
But still have another problem, may be related with my output
functions!?!?
>Indeed ... *please* tell us your compiler issued a warning about that.
I did shell scripts that suppress the warnings, so it was a big mistake, I
agree! But I think my problem is not here!
> Well, you oughta allocate result before you store into it, not after,
> and I bet you meant to assign to
tvi_char). Just date
types are allowed!
Any other suggestions??
Thanks!
-Original Message-
From: Jeremy Drake [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 4 de junho de 2007 00:23
To: Rodrigo Sakai
Cc: PostgreSQL Hackers
Subject: Re: [HACKERS] ERROR: index row size
Just glancing at
Hello,
Ok, I give up! Tried a lot of things in my code! But still get error on
index row size. So, I'm part of my code, if someone could help me! A valid
value for this type is: '(03-jan-2007 , 15-may-2010)'
typedef struct t_periodo
{
DateADT tvi;
DateADT
Hello,
I'm having a big trouble with the index size! I have looked for a solution
in the internet, but the solutions that I found don't fit for me!
I developed a new data type using C and add this new type on PostgreSQL.
Basically, the data type is: (DateADT, DateADT) with some temporal
Hello,
I'm developing an application that needs a different data type. So, I have
implemented this new data type inside postgresql using C, as documentation
shows to.
Basically, the data type is a composition of two timestamps, like:
(timestamp, timestamp) and it is called 'period'. S
Hello,
I have a question about passing parameters to a C function. Imagine the
example by PostgreSQL:
PG_FUNCTION_INFO_V1(complex_add);
Datum
complex_add(PG_FUNCTION_ARGS)
{
Complex*a = (Complex *) PG_GETARG_POINTER(0);
Complex*b = (Complex *) PG_GETARG_P
know-how on the backend internals, how difficult
is it to develop this (3 operators + 1 index type)?
--
Best regards,
Rodrigo Hjort
http://icewall.org/~hjort
CELEPAR - Cia de Informática do Paraná - Brasil
http://www.pr.gov.br
That's pretty roundabout. We already expose (hex coded) pid.starttime as
a session identifier in log_line_prefix (it's the %c escape) so I don't
see any reason not to provide either the same thing directly in a
function, or at least to expose the backend pid.
That would be nice.
---
WHERE datname = current_database()
AND usename = session_user
AND client_addr = inet_client_addr()
AND client_port = inet_client_port();
Regards,
Rodrigo
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
How about those "pg_ts*" tables, which are specific for a database? Will they serve to the whole cluster?2006/6/7, Teodor Sigaev <[EMAIL PROTECTED]
>:OpenFTS never, but tsearch2 is possible. But it requires enough work to do, so I
have doubt that it will be done in 8.2...-- R
Oleg,
Actually I got PG 8.1.4 compiled from source on a Debian GNU/Linux 2.6.16-k7-2.
My locale is pt_BR, but I configured TSearch2 to use rules from the 'simple'.
Then I just followed the instructions from the link. The fact is that it only works at the first time.
Regards,
Rodrigo
#x27;hundred':10(1 registro)fuzzy=# select to_tsvector('the quick brown fox jumped over the lazy dog 100');
server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.A conexão com servidor foi perdida. Tentando reiniciar: Falhou.
!> \qRegards,Rodrigo Hjorthttp://icewall.org/~hjort
* from table where field like 'THE NAME%'; -- index scanselect * from table where field like '%THE NAME%'; -- seq scanselect * from table where field like :bind_param; -- seq scan (always)Regards,
Rodrigo Hjort
http://icewall.org/~hjort
%' on static text or bound paremeter, makes the planner always do a sequential scan. Is that the scenario?-- Rodrigo Hjorthttp://icewall.org/~hjort
2006/5/23, Tom Lane <[EMAIL PROTECTED]>:
"Rodrigo Hjort" <[EMAIL PROTECTED]> writes:> What happens is that only the "004
t;); ps = con.prepareStatement(sql2); inicio = System.currentTimeMillis
(); rs = ps.executeQuery(); rs.next(); qtd = rs.getLong(1); rs.close(); tempo[3] = System.currentTimeMillis() - inicio; ps.close();
co
Thanks all. I'm gonna try other locales and encodings.2006/3/29, Tom Lane <[EMAIL PROTECTED]>:
"Rodrigo Hjort" <[EMAIL PROTECTED]> writes:> The fact is that I can't raise PostgreSQL with C encoding, as special> characters are used on most tables.
You're c
- 36 | GABRIELA HELEDA DE SOUZA 37 | GABRIELA JACOBY NOS
38 | GABRIEL ALCIDES KLIM PERONDI 39 | GABRIELA LETICIA BATISTA NUNES 40 | GABRIEL ALEXANDRE DA SILVA MANICA(5 rows)--Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation
732.331.1324-- Regards,Rodrigo HjortGTI - Projeto PostgreSQLCELEPAR - Cia de Informática do Paranáhttp://www.pr.gov.br
Pg-Hackers,I'm having the following issue:create table aluno (id serial, nome varchar(60));rodrigo=# select * from aluno order by nome offset 35 limit 5; id | nome+---
36 | GABRIELA HELEDA DE SOUZA 37 | GABRIELA JACOBY NOS 38 | GABRIEL AL
n't have the uptime requirement it probably doesn't make sense.--Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]Pervasive Software
http://pervasive.com work: 512-231-6117vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
-- Regards,Rodrigo HjortGTI - Projeto PostgreSQLCELEPAR - Cia de Informática do Paranáhttp://www.pr.gov.br
64-bit integersMaximum length of locale name: 128LC_COLLATE: pt_BRLC_CTYPE: pt_BR**
Regards,Rodrigo HjortGTI - Projeto PostgreSQLCELEPAR - Cia de Informática do Paranáhttp://www.pr.gov.br
temp); }// pfree(temp); // doesn't work...}// 3)void delstr(char *str, const int start, const int size){ int i, j;
char* temp = palloc(strlen(str) - size + 1); for (i = 0; (i < start - 1) && (i < strlen(str)); i++) temp[i] = str[i]; for (j = start + size - 1; j &l
Hi,
Thanks a Lot, it works.
So when it was changed (use of postgresql=YES), because I1m still use the
old way, download sources from postgres mirros, compile and install.
Best Regards
Rodrigo
-Mensagem original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Em nome de Christopher
Hi All,
The pg_autovacuum on FreeBSD and pg 803 is not working. Just do nothing, no
log, nothing in screen, no daemonize.
It was ok on pg746.
Could some one help me ?
Best Regards
Rodrigo Moreno
---(end of broadcast)---
TIP 6: Have you searched
Hi !
I am quite confused of the results on a SELECT max...
My environment:
Conectiva Linux 10, PostgreSQL 7.4.6 (compiled from the sources)
My problem is the "select max(id) FROM test" the result is 20 but the
right is 1020. Is this a BUG or I am crazy ??
Cheers,
Rodrigo Carvalha
and each fragment is located on different places
(postgresql servers)? See that the Data Base is Unique, but the Data are
distributed throught a horizontal partitioning. How PostgreSQL could
help me to solve this problem?
Thanks,
Rodrigo.
---(end of broadcast
Shridhar Daithankar wrote:
Just stumbled upon this. just an FYI,
http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
Shridhar
From the page:
> A new Snapshot Isolation (SI) level will be provided at the
> database level. With SI, users will be able to access the
> last committed ro
66 matches
Mail list logo