I'm trying to build something (pljava, dont laugh) for IBM AIX (don't
laugh). I have my own build of postgresql 9.1.6 on AIX, compiled with
IBM XLC, it works quite nicely, but this build is bombing..
...
/opt/pgsql91/lib/pgxs/src/makefiles/../../src/backend/port/aix/mkldexport.sh
libpljav
On 09/10/12 09:39, Daniel Serodio (lists) wrote:
We are preparing a PostgreSQL database for production usage and we
need to estimate the storage size for this database. We're a team of
developers with low expertise on database administration, so we are
doing research, reading manuals and using
Dean Myerson writes:
> I need to create some triggers and the docs seem pretty straightforward.
> When I tried to create one using CREATE TRIGGER, it took over 20
> minutes, and the second one hadn't finished over more than an hour. And
> I later found that all other database users in the compa
I need to create some triggers and the docs seem pretty straightforward.
When I tried to create one using CREATE TRIGGER, it took over 20
minutes, and the second one hadn't finished over more than an hour. And
I later found that all other database users in the company were locked
out during thi
We are preparing a PostgreSQL database for production usage and we need
to estimate the storage size for this database. We're a team of
developers with low expertise on database administration, so we are
doing research, reading manuals and using our general IT knowledge to
achieve this.
We ha
marian krucina writes:
> pg_upgrade failed on own server, because we used functions from public
> schema in index. We install common functions (e.g. postgresql contrib)
> to public schema. Tables and indexes are in another schema, and names
> of functions without a schema name.
Are you sure that
Run a query against the "pg_stat_activity" system view (you will need to be
a super-user to view system queries, normal users can only view their own).
To get you started this is the query that I use to spot-check system query
activity:
SELECT procpid, current_query, client_addr, xact_start
Hi Everybody,
I wanted to know if vacuum is already running in postgres?
Thank you,
Sireesha
2012/10/8 Ralf Schuchardt
>
>
> Using sysctl to set the shm* values has consistently worked for us in the
> last years ...
>
> probably i missed that point because my last install of postgres was on
ubuntu...
>
> Mountain Lion comes with it's own version of PostgreSQL. The included psql
> comma
Thanks Merlin,
I've tried arrays but plpython does not support returning arrays of custom
db types (which is what I'd need to do)
On Monday, 8 October 2012, Merlin Moncure wrote:
> On Mon, Oct 8, 2012 at 3:14 PM, Seref Arikan
> > wrote:
> > Greetings,
> > I have a binary blog which is passed to
"BEFORE INSERT" was the problem here, "AFTER INSERT" works fine
Thanks for all answers.
--
Regards,
Grzegorz
W dniu 2012-08-31 20:41, Grzegorz Tańczyk pisze:
Hello,
W dniu 2012-08-31 20:25, David Johnston pisze:
The question becomes how do you update the "item id" on the "groups"
table wh
Am 08.10.2012 um 02:08 schrieb Yvon Thoraval :
> 2012/10/7 Scott Marlowe
> 'd have posted more, but
>
> 1: I know just enough about MacOS to be dangerous and
> 2: MacOS is known for changing how shared memory works from one minor
> patch to another so..
> 3: Any page on making work will be depe
On Mon, Oct 8, 2012 at 3:14 PM, Seref Arikan
wrote:
> Greetings,
> I have a binary blog which is passed to a plpython function by a plpgsql
> function. plpython is used to create 2 different transformations of this
> binary blob to sets of postgresql type instances.
> The flow is: blob -> plpytho
Greetings,
I have a binary blog which is passed to a plpython function by a plpgsql
function. plpython is used to create 2 different transformations of this
binary blob to sets of postgresql type instances.
The flow is: blob -> plpython -> canonical python based data model ->
(set of db_type_As +
On Mon, Oct 8, 2012 at 1:36 AM, gelin yan wrote:
>
>
> On Mon, Oct 8, 2012 at 1:56 PM, Scott Marlowe
> wrote:
>> If the OP needs > 100 connections on the app end, he should add a
>> connection pooler like pgbouncer or pgpool. pgbouncer is the easier
>> of the two to configure.
>
>
>
> Hi
>
>
On Sat, Oct 6, 2012 at 5:24 AM, Adrian Klaver wrote:
> One thing I see above:
> http://pgbouncer.projects.postgresql.org/doc/config.html
> ""\*" acts as fallback database"
>
> Notice the backslash.
The backslash is asciidoc/docbook accident, it should be plain * there.
--
marko
--
Sent via p
On Tue, Oct 2, 2012 at 12:27 PM, Phoenix Kiula wrote:
> I get this error:
>
>psql: ERROR: No such user: MYSITE_MYSITE
>
> And yet, the authfile has this:
>
> "MYSITE_MYSITE" ""
> "MYSITE_MYSITE" ""
> "postgres" ""
> "MYSITE_pgbouncer" ""
Because of data sanitizing I cannot se
shehab adean sherif wrote:
> where should be the location of pgsql_tmp directory of specific
database i've searched in
> /var/lib/postgresql/9.1/main/base/database OID and i didn't find it,
should i create it by my self?
This directory does not belong to a database, but to a tablespace.
For the de
On Mon, Oct 8, 2012 at 1:56 PM, Scott Marlowe wrote:
> On Sun, Oct 7, 2012 at 9:27 PM, gelin yan wrote:
> >
> >
> > On Mon, Oct 8, 2012 at 9:02 AM, Haiming Zhang <
> haiming.zh...@redflex.com.au>
> > wrote:
> >>
> >> Hi all,
> >>
> >>
> >>
> >> I am Haiming, a software engineer.
> >>
> >>
> >>
>
19 matches
Mail list logo
