On Sat, Oct 7, 2017 at 2:37 PM, Daniele Varrazzo
wrote:
> (with a
> custom addition to update the relfrozenxid which seems backwards to me
> as it sets the older frozen xid on the new table [3]).
>
> [3] https://github.com/reorg/pg_repack/issues/152
Wow. That's really bad. It will corrupt your
On 08/10/17 15:21, Craig Ringer wrote:
> On 8 October 2017 at 02:37, Daniele Varrazzo
> wrote:
>> Hello,
>>
>> we have been reported, and I have experienced a couple of times,
>> pg_repack breaking logical replication.
>>
>> - https://github.com/reorg/pg_repack/issues/135
>> - https://github.com/
On 8 October 2017 at 02:37, Daniele Varrazzo wrote:
> Hello,
>
> we have been reported, and I have experienced a couple of times,
> pg_repack breaking logical replication.
>
> - https://github.com/reorg/pg_repack/issues/135
> - https://github.com/2ndQuadrant/pglogical/issues/113
Yeah, I was going
Thanks for your clues.
The system I have used to debug the code is x86 64bit based, Ubuntu 1404
and postgres 9.3.13, I have revised the code and it looks like as following:
Datum vquery(PG_FUNCTION_ARGS) {
int array_len = PG_GETARG_INT32(0);
int64 * node_ids;
ArrayType * retarr;
Datum * vals ;
=?UTF-8?B?6ZKx5paw5p6X?= writes:
> I have written an extension to manage openstreetmap data. There is a C
> function to perform spatial top k query on several tables and return an
> array of int8 type as result. The code skeleton of this function is as
> follows:
There are a remarkable lot of bu
On Fri, Feb 17, 2017 at 5:21 PM, Tom Lane wrote:
> Stephen Frost writes:
> > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> >> Magnus Hagander wrote:
> >>> I'm guessing if we backpatch something like that, it would cause
> issues for
> >>> translations, right? So we should make it head onl
Stephen Frost writes:
> * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
>> Magnus Hagander wrote:
>>> I'm guessing if we backpatch something like that, it would cause issues for
>>> translations, right? So we should make it head only?
>> We've had the argument a number of times. My stand is t
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> Magnus Hagander wrote:
> > On Wednesday, February 15, 2017, Alvaro Herrera
> > wrote:
> >
> > > Magnus Hagander wrote:
> > >
> > > > printf(_(" -R, --write-recovery-conf\n"
> > > > - " write r
Magnus Hagander wrote:
> On Wednesday, February 15, 2017, Alvaro Herrera
> wrote:
>
> > Magnus Hagander wrote:
> >
> > > printf(_(" -R, --write-recovery-conf\n"
> > > - " write recovery.conf
> > after backup\n"));
> > > + "
On Wednesday, February 15, 2017, Alvaro Herrera
wrote:
> Magnus Hagander wrote:
>
> > printf(_(" -R, --write-recovery-conf\n"
> > - " write recovery.conf
> after backup\n"));
> > + " write recovery.co
Magnus Hagander wrote:
> printf(_(" -R, --write-recovery-conf\n"
> - " write recovery.conf after
> backup\n"));
> + " write recovery.conf for
> replication\n"));
> printf(_(" -S, --slot=SLOTNA
Hi all,
Thank you for all of your responses.
Meanwhile, I will repost this at pgsql-gene...@postgresql.org
Regards,
Fattah
On 09/12/2015, David G. Johnston wrote:
> On Tue, Dec 8, 2015 at 4:43 PM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Tue, Dec 8, 2015 at 3:33 AM, Fat
On Tue, Dec 8, 2015 at 4:43 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, Dec 8, 2015 at 3:33 AM, FattahRozzaq wrote:
>
>> Hi all,
>>
>> Please help...
>>
>> I have 1 master PostgreSQL and 1 standby PostgreSQL.
>> Both servers has the same OS Linux Debian Wheezy, the same h
On Tue, Dec 8, 2015 at 3:33 AM, FattahRozzaq wrote:
> Hi all,
>
> Please help...
>
> I have 1 master PostgreSQL and 1 standby PostgreSQL.
> Both servers has the same OS Linux Debian Wheezy, the same hardware.
>
> Both server hardware:
> CPU: 24 cores
> RAM: 128GB
> Disk-1: 800GB SAS (for OS, logs
On Tue, Dec 8, 2015 at 7:33 PM, FattahRozzaq wrote:
> The WAL archive is at /home/postgres/archive/master/, right?
> This directory consume more than 750GB of Disk-1.
> Each segment in the /home/postgres/archive/master/ is 16MB each
> There are currently 47443 files in this folder.
>
> I want to l
On 29 April 2015 at 21:45, Szymon Guz wrote:
> Hi Devrim,
> I will take a look at this.
>
> regards,
> Szymon
>
> On 29 April 2015 at 18:24, Devrim Gündüz wrote:
>
>>
>> Hi,
>>
>> Anyone? :)
>>
>> Regards, Devrim
>>
>> On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote:
>> > Hi,
>> >
>> > Ba
Hi Devrim,
I will take a look at this.
regards,
Szymon
On 29 April 2015 at 18:24, Devrim Gündüz wrote:
>
> Hi,
>
> Anyone? :)
>
> Regards, Devrim
>
> On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote:
> > Hi,
> >
> > Background info first: PL/Ruby was originally maintained by Guy Decoux,
>
Hi,
Anyone? :)
Regards, Devrim
On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote:
> Hi,
>
> Background info first: PL/Ruby was originally maintained by Guy Decoux,
> who passed away in 2008: https://www.ruby-forum.com/topic/166658 . After
> his death, Akinori MUSHA forked the project and
On Thu, Feb 12, 2015 at 3:27 AM, hailong Li wrote:
> Hi, dear pgsql-hackers
Please have a look at
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
This is the wrong mailing list for this sort of question, and your
report is pretty unclear, so it's hard to tell what might have gone
wr
Michael Paquier wrote:
> On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer wrote:
> > On 09/17/2014 01:51 AM, Tapan Halani wrote:
> >> Hello everyone..i am new to PostgreSQL project. I had prior experience
> >> with sql+ , with oracle 11g database server. Kindly help me grasp more
> >> about the proje
On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer wrote:
> On 09/17/2014 01:51 AM, Tapan Halani wrote:
>> Hello everyone..i am new to PostgreSQL project. I had prior experience
>> with sql+ , with oracle 11g database server. Kindly help me grasp more
>> about the project.
>
> Since you're asking on pg
On 09/17/2014 01:51 AM, Tapan Halani wrote:
> Hello everyone..i am new to PostgreSQL project. I had prior experience
> with sql+ , with oracle 11g database server. Kindly help me grasp more
> about the project.
Since you're asking on pgsql-hackers, you're presumably interested in
getting involved
On 09/16/2014 01:51 PM, Tapan Halani wrote:
Hello everyone..i am new to PostgreSQL project. I had prior experience
with sql+ , with oracle 11g database server. Kindly help me grasp more
about the project.
The first thing you need to do is learn to ask your question in the
right forum.
On Wed, Oct 24, 2012 at 3:54 PM, Xiong He wrote:
> Is it possible to copy some table data from remote client to the PG
> database server directly without upload the data file to the server side in
> advance?
>
With a psql client you can use the command ¥copy to perform that.
--
Michael Paquier
h
You can use the libpq API:
http://www.postgresql.org/docs/9.2/interactive/libpq-copy.html
The Postgresql JDBC driver exposes COPY, IIRC.
From: pgsql-hackers-ow...@postgresql.org
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Xiong He
Sent: Tuesday, October 23, 2012 11:55 PM
To: Postgr
On 29 July 2012 16:39, Peter Geoghegan wrote:
> Many of you will be aware that the behaviour of commit_delay was
> recently changed. Now, the delay only occurs within the group commit
> leader backend, and not within each and every backend committing a
> transaction:
I've moved this to the pgsql-
Peter,
For some reason I didn't receive the beginning of this thread. Can you
resend it to me, or (better) post it to the pgsql-performance mailing list?
I have a linux system where I can test both on regular disk and on SSD.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sen
> From: Peter Geoghegan [mailto:pe...@2ndquadrant.com]
> Sent: Wednesday, August 01, 2012 8:49 PM
On 1 August 2012 15:14, Amit Kapila wrote:
>> I shall look into this aspect also(setting commit_delay based on raw
sync).
>> You also suggest if you want to run the test with different
configuration
On 1 August 2012 15:14, Amit Kapila wrote:
> I shall look into this aspect also(setting commit_delay based on raw sync).
> You also suggest if you want to run the test with different configuration.
Well, I was specifically interested in testing if half of raw sync
time was a widely useful setting
> From: pgsql-hackers-ow...@postgresql.org
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Peter Geoghegan
> Sent: Sunday, July 29, 2012 9:09 PM
> I made what may turn out to be a useful observation during the
> development of the patch, which was that for both the tpc-b.sql and
> insert
On Sep 2, 2011, at 2:59 PM, Hannu Krosing wrote:
> On Fri, 2011-09-02 at 14:51 +0200, PostgreSQL - Hans-Jürgen Schönig
> wrote:
>> hello …
>>
>> the goal of the entire proxy thing is to make the right query go to the
>> right node / nodes.
>> we determine this by using a partitioning function a
On Fri, 2011-09-02 at 14:51 +0200, PostgreSQL - Hans-Jürgen Schönig
wrote:
> hello …
>
> the goal of the entire proxy thing is to make the right query go to the right
> node / nodes.
> we determine this by using a partitioning function and so on …
> currently PL/proxy has only a handful of comman
hello …
the goal of the entire proxy thing is to make the right query go to the right
node / nodes.
we determine this by using a partitioning function and so on …
currently PL/proxy has only a handful of commands - one is RUN ON … which tells
us where to put things.
assume you issue a select … s
On Fri, 2011-09-02 at 14:01 +0200, PostgreSQL - Hans-Jürgen Schönig
wrote:
> hello …
>
> i have been thinking about this issue for quite a while ...
> given your idea i am not sure how this can work at all.
>
> consider:
> begin;
> insert 1
> insert 2
> commit
>
> assume
hello …
i have been thinking about this issue for quite a while ...
given your idea i am not sure how this can work at all.
consider:
begin;
insert 1
insert 2
commit
assume this ends up in the same node,
now you split it into two …
1 and 2 will have exactly the sa
On Jul 13, 2011, at 12:29 PM, "Fernando Acosta Torrelly"
wrote:
> Hi everybody:
>
> I am using pgmail to send email in an application, but I would like to use
> html format
>
> Does anybody has an example how to do this?, or what do you recommend me to
> use por doing this?
>
> Thanks in adv
nil nil wrote:
> Hello,
> ?? Sir, i am a student. i want to develop a patch for postgresql. but
> i dont know how to take the step.kindly guide me for this.
Sure, look here:
http://developer.postgresql.org
--
Bruce Momjian http://momjian.us
EnterpriseDB
nil nil wrote:
> i want to develop a service for postgresql related to querry
> processing.but i dont know how to develop it. plz guide me so that
> i can take step.
I think the root of all information on that is here:
http://www.postgresql.org/developer/
with the linked developer FAQ bein
On fre, 2011-02-25 at 21:32 +0200, Peter Eisentraut wrote:
> According to the online documentation, the APIs are there:
> http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx
>
> Now we'd need someone brave try to make it work. The starting point
> would be to define HAVE_LOCALE_T and then make
On Fri, Feb 25, 2011 at 22:58, Dave Page wrote:
> On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan wrote:
>>
>>
>> On 02/25/2011 02:32 PM, Peter Eisentraut wrote:
>>>
>>> According to the online documentation, the APIs are there:
>>> http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx
>>>
>>> No
On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan wrote:
>
>
> On 02/25/2011 02:32 PM, Peter Eisentraut wrote:
>>
>> According to the online documentation, the APIs are there:
>> http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx
>>
>> Now we'd need someone brave try to make it work. The startin
On 02/25/2011 02:32 PM, Peter Eisentraut wrote:
According to the online documentation, the APIs are there:
http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx
Now we'd need someone brave try to make it work. The starting point
would be to define HAVE_LOCALE_T and then make it build. Micros
On Tue, Sep 28, 2010 at 6:16 PM, Magnus Hagander wrote:
> We're talking about the "export all symbols" thing, right? I *don't*
> think we want to recommend people to do that - it creates bloated DLL
> files, for no really good reason. Also, it's not just a matter of a
> msvc project - we do that w
Magnus Hagander escreveu:
> We might, however, want to add a specific section to the
> *documentation* about building extensions on Windows.
>
+1.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to
On Tue, Sep 28, 2010 at 09:26, Itagaki Takahiro
wrote:
> On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane wrote:
>>> As I mentioned, we don't need the marks in our build environment at all.
>>
>> In that case, anybody who does need it should fix their build
>> environment.
>>
>> I grow really weary of t
On 28/09/10 11:09, Itagaki Takahiro wrote:
> On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas wrote:
>>> Since we have PGDLLEXPORT in 9.0, we can mark some of exported
>>> functions with it in tutorial codes and maybe contrib modules.
>>
>> If that (a) works and (b) reduces user confusion, +1 from me.
On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane wrote:
>> As I mentioned, we don't need the marks in our build environment at all.
>
> In that case, anybody who does need it should fix their build
> environment.
>
> I grow really weary of the idea that we should submit to arbitrary
> amounts of uglifica
Itagaki Takahiro writes:
> On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas wrote:
>> Oh - I didn't realize this meant marking lots of things in contrib
>> that didn't otherwise need to be marked. Â Why do other people need
>> this if we don't?
> As I mentioned, we don't need the marks in our build
On Mon, Sep 27, 2010 at 11:26 PM, Itagaki Takahiro
wrote:
> On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas wrote:
>>> If we do so, many PGDLLEXPORT will be added:
>>> * 17 in src/tutorial
>>> * 507 in contrib
>>> for each exported PGFunction, _PG_init, and _PG_fini.
>>
>> Oh - I didn't realize
On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas wrote:
>> If we do so, many PGDLLEXPORT will be added:
>> * 17 in src/tutorial
>> * 507 in contrib
>> for each exported PGFunction, _PG_init, and _PG_fini.
>
> Oh - I didn't realize this meant marking lots of things in contrib
> that didn't otherwis
On Mon, Sep 27, 2010 at 11:09 PM, Itagaki Takahiro
wrote:
> On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas wrote:
>>> Since we have PGDLLEXPORT in 9.0, we can mark some of exported
>>> functions with it in tutorial codes and maybe contrib modules.
>>
>> If that (a) works and (b) reduces user confus
On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas wrote:
>> Since we have PGDLLEXPORT in 9.0, we can mark some of exported
>> functions with it in tutorial codes and maybe contrib modules.
>
> If that (a) works and (b) reduces user confusion, +1 from me. We've
> gotten this question a few times lately
On Mon, Sep 27, 2010 at 8:45 PM, Itagaki Takahiro
wrote:
> On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira
> wrote:
>> Itagaki Takahiro escreveu:
>>> I had the same problems before, and I wrote some hacks for VC++.
>>>
>> Isn't there such a code in core or am i missing something? Is it
On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira
wrote:
> Itagaki Takahiro escreveu:
>> I had the same problems before, and I wrote some hacks for VC++.
>>
> Isn't there such a code in core or am i missing something? Is it worth
> supporting the VC++ standalone projects?
Since we have P
Itagaki Takahiro escreveu:
> I had the same problems before, and I wrote some hacks for VC++.
>
Isn't there such a code in core or am i missing something? Is it worth
supporting the VC++ standalone projects?
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-hackers ma
On Sun, Sep 26, 2010 at 12:56 AM, Esteban Zimanyi
wrote:
> When I run the examples there is a server crash. I used both Visual
> C++ 2008 and 2005 for building the dll. I also used both PostgreSQL
> versions 8.4 and 9.0. All versions produce the same problem.
>
> Do you know how can I solve the pr
Hi all,
I am having a project in Postgres where I had modified code in
gram.y...I have added new command along with grammer and returning
list of parse nodes as opposed to single node inside actions
blockI want to process each of them in postgres.c file...But, I
couldn't find any difference i
On Wed, Mar 26, 2008 at 11:10 PM, Pedro Belmino <[EMAIL PROTECTED]>
wrote:
> Hello,
> I am creating an agent that runs alongside the postgres written in c++, I
> have a question: How send sql queries directly for the database without
> going need to make any connection?
> What I call function, whi
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I need help understanding the following two release note items (see XXX):
I've tweaked the text for the first one. I do not think the second one
needs any changes; the matter is discussed elsewhere in the docs, and
the release notes are not the place to
,$(subdir)))
override CPPFLAGS+= -DBUILDING_DLL
endif
endif
- Original Message -
From: "Andrei Kovalevski" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 30, 2007 1:35 AM
Subject: Re: [HACKERS] Help! DLL make faild under windows mingw.
> Hi!
>
Hi!
What exactly are you trying to build? If you have own-written Makefile
for this - post it here. Does your code contain #define BUILDING_DLL
before inclusion of PostgreSQL headers?
Wang Haiyong wrote:
> I am doing a DLL project, it is in the backend/utils/mb. But it can
> not be maked under wi
Tasneem Memon <[EMAIL PROTECTED]> writes:
> Hi, I am Tasneem Memon doing MS Computer Science. I am working on my thesis=
> these days, for which I have defined some operators theoritically as well =
> as their algorithms, and intend to implement them in PostgreSQL. These oper=
> ators(NEAR, NOT NE
On Feb 25, 9:34 am, [EMAIL PROTECTED] (Andrew Dunstan) wrote:
> Phani Kishore wrote:
>
> > hi !
>
> > i think u people could probably help me i how to query the
> > pgsql/postgis from google maps api to display the markers on the
> > google maps which are stored in the postgis database.
> > Phani K
Phani Kishore wrote:
hi !
i think u people could probably help me i how to query the
pgsql/postgis from google maps api to display the markers on the
google maps which are stored in the postgis database.
Phani Kishore
Tata Consultancy Services
Mailto: [EMAIL PROTECTED]
Website: http://www.
You should take a look at http://pgfoundry.org/projects/qbe, which deals
with querying data by providing sample data that matches what you're
looking for.
On Wed, Jan 24, 2007 at 01:40:04PM -0400, Werner Echezuria wrote:
> Hello,
>
> I've suscribed to this mailing list for help, I will work on a
du li wrote:
Dear hackers,
I'm working on a windows application with C# language and use npgsql to connect postgres DB. I'm eager to learn how to make a solo setup file which included windows application and postgres DB. My develop environment is Visual Studio 2003 and Framework 1.1
I
Thank you for your reply.
I found my bug in the code which made the function behave strangely.
On Mon, 2006-09-11 at 14:23 +0530, Abhijit Menon-Sen wrote:
> At 2006-09-11 10:25:22 +0200, [EMAIL PROTECTED] wrote:
> >
> > What are we testing to be NULL here?
> > Do we expect str to changed at l
At 2006-09-11 10:25:22 +0200, [EMAIL PROTECTED] wrote:
>
> What are we testing to be NULL here?
> Do we expect str to changed at line 1715
No. (Read the comment just above the function.)
The code is like this, starting from line 1703:
if (str == NULL && flinfo->fn_strict)
return (Da
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> Unfortunately (perhaps) standards_conforming_strings does not appear
>> to be exported, so I'm not sure how to do this otherwise.
>
> Perhaps your problem is one of spelling? It's
> "standard_conforming_strings", an
Chris Browne <[EMAIL PROTECTED]> writes:
> Unfortunately (perhaps) standards_conforming_strings does not appear
> to be exported, so I'm not sure how to do this otherwise.
Perhaps your problem is one of spelling? It's
"standard_conforming_strings", and it's certainly a global variable.
You still
[EMAIL PROTECTED] (Peter Eisentraut) writes:
> Chris Browne wrote:
>> In support of PG 8.2, we need to have the log trigger function do the
>> following:
>> - Save value of standards_conforming_string
>> - Set value of standards_conforming_string to FALSE
>> - proceed with saving data to sl_l
Chris Browne <[EMAIL PROTECTED]> writes:
> In support of PG 8.2, we need to have the log trigger function do the
> following:
> - Save value of standards_conforming_string
> - Set value of standards_conforming_string to FALSE
This is a good idea why exactly? What are you even expecting it to
Chris Browne wrote:
> In support of PG 8.2, we need to have the log trigger function do the
> following:
> - Save value of standards_conforming_string
> - Set value of standards_conforming_string to FALSE
> - proceed with saving data to sl_log_?
> - Recover value of standards_conforming_str
On Thursday 06 July 2006 21:55, Martijn van Oosterhout wrote:
> On Thu, Jul 06, 2006 at 07:43:20PM +0300, Tzahi Fadida wrote:
> > The downside is that i noticed that the CTID is removed from the tuple
> > if a cast occurs. Is there a way to tell postgresql to not remove the
> > CTID?
>
> Err, the f
On Thu, Jul 06, 2006 at 07:43:20PM +0300, Tzahi Fadida wrote:
> The downside is that i noticed that the CTID is removed from the tuple
> if a cast occurs. Is there a way to tell postgresql to not remove the
> CTID?
Err, the fact the ctid is removed is really just a side-effect. With no
adjusting o
I looked around in the code and the whole thing looks complex
and prone to breaking my code often, i.e., whenever someone will decide to
change the casting/operators. I thought about just
issuing in SPI_prepare query the proper casting like:
SELECT a0::text,a1::text ...
Casting to equal types (whe
Martijn van Oosterhout writes:
> On Wed, Jun 28, 2006 at 03:25:57PM +0300, Tzahi Fadida wrote:
>> I need help finding out how to determine if two types are equality compatible
>> and compare them.
> Fortunatly the backend contains functions that do all this already.
> Check out parser/parse_oper.
On Wed, Jun 28, 2006 at 03:25:57PM +0300, Tzahi Fadida wrote:
> Hi,
>
> I need help finding out how to determine if two types are equality compatible
> and compare them.
> Currently i only allow two values only of the same type but i wish to allow
> to compare values like "20.2"=?20.2 or 20=?20
On 5/16/06, winlinchu <[EMAIL PROTECTED]> wrote:
I must to write a report on physical structures of DBMS's.
I choosed PostgreSQL; I looked the sources, and I have
understood the block structure. And relations? And databases?
How are structured?
Is there a question in there?
If you're looking f
"yy h" <[EMAIL PROTECTED]> writes:
> I was trying to modify the physical page layout in PostgreSQL.
Uh, why?
> I understand the source code for physical page organization is located
> at bufpage.c but I wonder what is the external interface for this
> physical page organization. Interface like I
On Nov 28, 2005, at 4:13 PM, Tom Lane wrote:
Yeah, could be. Anyway it doesn't seem like we can learn much more
today. You might as well just zing the vacuumdb process and let
things get back to normal. If it happens again, we'd have reason
to dig deeper.
Final report [ and apologies to ha
On Nov 28, 2005, at 1:46 PM, Tom Lane wrote:
James Robinson <[EMAIL PROTECTED]> writes:
backtrace of the sshd doesn't look good:
Stripped executable :-( ... you won't get much info there. What of
the client at the far end of the ssh connection? You should probably
assume that the blockage
James Robinson <[EMAIL PROTECTED]> writes:
> Given the other culprits in play are bash running a straightforward
> shellscript line with redirected output to a simple file on a non-
> full filesystem, I'm leaning more towards the odds that something
> related to the sshd + tcp/ip + ssh client
James Robinson <[EMAIL PROTECTED]> writes:
> backtrace of the sshd doesn't look good:
Stripped executable :-( ... you won't get much info there. What of
the client at the far end of the ssh connection? You should probably
assume that the blockage is there, rather than in a commonly used bit
of s
On Nov 28, 2005, at 12:00 PM, Tom Lane wrote:
Your next move is to look at the state of sshd
and whatever is running at the client end of the ssh tunnel.
backtrace of the sshd doesn't look good:
(gdb) bt
#0 0xe410 in ?? ()
#1 0xbfffdb48 in ?? ()
#2 0x080a1e28 in ?? ()
#3 0x080a1e78
James Robinson <[EMAIL PROTECTED]> writes:
> On Nov 28, 2005, at 11:38 AM, Tom Lane wrote:
>> Can you get a similar backtrace from the vacuumdb process?
> OK:
> (gdb) bt
> #0 0xe410 in ?? ()
> #1 0xbfffe4f8 in ?? ()
> #2 0x0030 in ?? ()
> #3 0x08057b68 in ?? ()
> #4 0xb7e98533 in
On Nov 28, 2005, at 11:38 AM, Tom Lane wrote:
Can you get a similar backtrace from the vacuumdb process?
(Obviously,
give gdb the vacuumdb executable not the postgres one.)
OK:
(gdb) bt
#0 0xe410 in ?? ()
#1 0xbfffe4f8 in ?? ()
#2 0x0030 in ?? ()
#3 0x08057b68 in ?? ()
#4 0xb7e
James Robinson <[EMAIL PROTECTED]> writes:
> (gdb) bt
> #0 0xe410 in ?? ()
> #1 0xbfffd508 in ?? ()
> #2 0x082aef97 in PqSendBuffer ()
> #3 0xbfffd4f0 in ?? ()
> #4 0xb7ec03e1 in send () from /lib/tls/libc.so.6
> #5 0x08137d27 in secure_write ()
> #6 0x0813c2a7 in internal_flush ()
> #7
Here ya go -- BTW -- your guys support is the _best_. But you know
that already:
[EMAIL PROTECTED]:/home/sscadmin> gdb /usr/local/pgsql/bin/postgres 19244
GNU gdb 6.2.1
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and
you are
w
James Robinson <[EMAIL PROTECTED]> writes:
> As fate would have it, the vacuumdb frontend and backend which were
> initially afflicted are still in existence:
OK, so pid 19244 isn't blocked on any lmgr lock; else we'd see an entry
with granted = f for it in pg_locks. It could be blocked on a lo
As fate would have it, the vacuumdb frontend and backend which were
initially afflicted are still in existence:
sscadmin 19236 19235 0 Nov25 ?00:00:00 /usr/local/pgsql/bin/
vacuumdb -U postgres --all --analyze --verbose
postgres 19244 3596 0 Nov25 ?00:00:02 postgres: postgre
James Robinson <[EMAIL PROTECTED]> writes:
> Comparing the logs further with when it did complete, it seems that
> one table in particular (at least) seems afflicted:
> social=# vacuum verbose analyze agency.swlog_client;
> hangs up forever -- have to control-c the client. Likewise for w/o
>
-general@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Help with Array Function in C language...
"Cristian Prieto" <[EMAIL PROTECTED]> writes:
> Datum
> test_array(PG_FUNCTION_ARGS)
> {
> ArrayType *v = PG_GETARG_ARRAYTYPE_P(1);
>
"Cristian Prieto" <[EMAIL PROTECTED]> writes:
> Datum
> test_array(PG_FUNCTION_ARGS)
> {
> ArrayType *v = PG_GETARG_ARRAYTYPE_P(1);
> Datum element;
> Oidarray_type = get_array_type(v);
I think you want get_element_type, instead. And you definitely ought to
be check
Did you not see the posts by Richard and Dennis?
ElayaRaja S wrote:
Hi,
I am unable to restart the PostgreSQL. I am using redhat Linux 9
with postgresql 7.4.5. Unexpectedly due to ups problem my server was
shutdown once. After that i am unable to restart the server. How to
stop and start.
Present s
ElayaRaja S wrote:
Hi,
I am unable to restart the PostgreSQL. I am using redhat Linux 9
with postgresql 7.4.5. Unexpectedly due to ups problem my server was
shutdown once. After that i am unable to restart the server. How to
stop and start.
Present status is running. If i tried to start i am ge
On Fri, 15 Apr 2005, ElayaRaja S wrote:
> Hi,
> I am unable to restart the PostgreSQL. I am using redhat Linux 9
> with postgresql 7.4.5. Unexpectedly due to ups problem my server was
> shutdown once. After that i am unable to restart the server.
> DETAIL: The data directory was initialized by
strk <[EMAIL PROTECTED]> writes:
> On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
>> *What* is giving this error? Something seems to be holding onto a
>> reference to (at a guess) your temporary table. Can you identify what?
> Whatever is called from create temp table ..
"\set V
On Wed, Mar 23, 2005 at 02:49:53PM +, Richard Huxton wrote:
> strk wrote:
> >On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
> >
> >>strk wrote:
> >>
> >>>Hello.
> >>>A memory fault in a trigger left my database
> >>>in a corrupted state:
> >>>
> >>
> >>> - I can't create temp
strk wrote:
On Wed, Mar 23, 2005 at 01:48:11PM +, Richard Huxton wrote:
strk wrote:
Hello.
A memory fault in a trigger left my database
in a corrupted state:
- I can't create temporary tables anymore
(restart/vacuum full don't help)
ERROR: cache lookup failed for r
1 - 100 of 224 matches
Mail list logo
