Hi All,
I’ve just made a clean install for PostgreSQL 9.1 (postgresql-server-9.1.4,
postgresql-contrib-9.1.4) on a FreeBSD 9 (FreeBSD 9.0-RELEASE-p3 FreeBSD
9.0-RELEASE-p3 #0: Tue Jun 12 02:52:29 UTC 2012
r...@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64).
I’ve
We are getting a strange thing happening if the lo_export(attr, path)
destination is a fifo.
First, in the normal case, there is output to the file but also
feedback to stdout (or somewhere, appearing on the VT screen) of the
number 1.
---
1
(1 row)
Now, if the destination file
On Wed, 15 Aug 2012, Neanderthelle Jones wrote:
> So it seems to us that the lo_export output can't be piped (via a
> named pipe) to another process that reads from the pipe and expects
> the valid BLOB contents.
I should have said that the BLOB is a PDF and the file that results
from cat fifo >m
As I understand it, I am allowed to redistribute Postgres so long as I
include the copyright notice plus paragraphs as detailed on
http://www.postgresql.org/about/licence/.
What I want to confirm is that the one-click installer (which I
understand was supplied by EnterpriseDB) can also be redi
> >> Can anyone advice about a tool to visualize a database schema?
> >
> > SQLalchemy, a Python module, can produce dot (Graphviz) output
> > which you can load into your favourite diagramming application such
> > as e.g. Omnigraffle, yEd or Dia:
> >
> > http://www.sqlalchemy.org/trac/wiki/UsageRe
I run the same config (FreeBSD 9 with PG 9.1.x) on couple of servers, and
they seem to be working fine without any error messages. The only other
setting I have in my sysctl.conf is kern.maxfiles .
Amitabh
On Wed, Aug 15, 2012 at 1:27 PM, Carl von Clausewitz wrote:
> Hi All,
>
> ** **
>
> I
On 15 August 2012 09:57, Carl von Clausewitz wrote:
> I’ve restored from TAR backup our databases, and everything looked fine.
What exactly is in that TAR backup? Is that a tar/gzipped PG dump or a
file-system snapshot?
If the latter:
- did you halt the database while creating the snapshot or at
"Carl von Clausewitz" writes:
> Iâve restored from TAR backup our databases, and everything looked fine.
> Without changing any setting in postgresql.conf (or in kernel settings) â
> only âtrack_counts=onâ, after 2-3 days, Iâm receiving huge number
> (~5-10 PCS in every second) of err
On Wed, Aug 15, 2012 at 11:45:21AM +0100, Andrew Hastie wrote:
> As I understand it, I am allowed to redistribute Postgres so long as
> I include the copyright notice plus paragraphs as detailed on
> http://www.postgresql.org/about/licence/.
>
> What I want to confirm is that the one-click install
On Wed, Aug 15, 2012 at 3:17 PM, Bruce Momjian wrote:
> On Wed, Aug 15, 2012 at 11:45:21AM +0100, Andrew Hastie wrote:
>> As I understand it, I am allowed to redistribute Postgres so long as
>> I include the copyright notice plus paragraphs as detailed on
>> http://www.postgresql.org/about/licence
On Wed, Aug 15, 2012 at 03:20:52PM +0100, Dave Page wrote:
> On Wed, Aug 15, 2012 at 3:17 PM, Bruce Momjian wrote:
> > On Wed, Aug 15, 2012 at 11:45:21AM +0100, Andrew Hastie wrote:
> >> As I understand it, I am allowed to redistribute Postgres so long as
> >> I include the copyright notice plus p
Hi All,
I want to write a MS-DOS command to check that the PostgreSQL database is up
and running and able to accept data being pushed to it. From a bit of reading
I've identified the pg_ctl status command, but can this be incorporated into a
*.bat file and can the resulting status be recorded i
On Wed, Aug 15, 2012 at 09:52:17AM +, Loughrey, Hugh wrote:
> Hi All,
>
> I want to write a MS-DOS command to check that the PostgreSQL database is up
> and running and able to accept data being pushed to it. From a bit of reading
> I’ve identified the pg_ctl status command, but can this be i
On Wed, Aug 15, 2012 at 4:04 PM, Bruce Momjian wrote:
> On Wed, Aug 15, 2012 at 09:52:17AM +, Loughrey, Hugh wrote:
>> Hi All,
>>
>> I want to write a MS-DOS command to check that the PostgreSQL database is up
>> and running and able to accept data being pushed to it. From a bit of reading
>>
Hi there,
This is my first post in the list.
I'm a PostgreSQL user in the linux world but at the office there is a Mac
computer and I have a problem with postgres in it.
The problem is when I use characters with tildes in spanish like in the
follow word "países".
The next is ilustrates my problem
Original message:
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de Marc Watson
Envoyé : June-11-12 8:36 AM
À : Craig Ringer
Cc : pgsql-general@postgresql.org; dp...@pgadmin.org;
sachin.srivast...@enterprisedb.com
Objet : Re: [GENERAL] Postgres
Hi all,
I managed to compile postgresql on BeagleBone.
The only problem I encountered was insufficient memory for compiling
grammars by bison (BeagleBone has 256MB RAM).
As a workaround, I compiled the same sources on a bigger machine and
copied the following files to BeagleBone:
postgresql/src
Hi,
I've made the backups with pg_dump, compressed, and there wasn't any kind of
error messages. I've made the restoration with pgAdmin (but it also uses
pg_dump for restore).
How can I check if the statistics are corrupt?
regards,
Csaba
-Original Message-
From: Alban Hertroys [mail
Hi,
I've made the kernel changes that I wrote in my original e-mail, and I've
created some additional logging (both csvlog and syslog), to gather more
informations.
/boot/loader.conf:
kern.ipc.semmni="512"
kern.ipc.semmns="1024"
kern.ipc.semume="64"
kern.ipc.semmnu="512"
/etc/sysctl.cong:
k
I'm porting some code from an Oracle application and we have many uses of set
returning function. In particular, we are using them in joins of the form:
CREATE TABLE dave ( id integer, field1 integer );
INSERT INTO dave VALUES (1, 10);
SELECT
id, g.*
FROM
dave
On Aug 15, 2012, at 15:55, David Greco wrote:
> I’m porting some code from an Oracle application and we have many uses of set
> returning function. In particular, we are using them in joins of the form:
>
> CREATE TABLE dave ( id integer, field1 integer );
> INSERT INTO dave VALUES (1, 10);
>
Not sure how to write the CTE form of this. This query gives an error that dave
is missing a from clause entry.
WITH o as (
SELECT getRecord(1, dave.field1)
)
SELECT
id, o.*
FROM
dave
;
Regarding the INNER JOIN, actually it appears the opposite i
On Aug 7, 2012, at 11:55 AM, Steve Atkins wrote:
> Something like this?
>
> select 12 * extract(year from ?) + extract(month from ?) + extract(epoch from
> ? - date_trunc('month', ?)) / 2592000
>
> Ugly, but likely closer to accurate. You can't get actually accurate, of
> course, as you don't
Inline comments:
On Aug 15, 2012, at 16:24, David Greco wrote:
> Not sure how to write the CTE form of this. This query gives an error that
> dave is missing a from clause entry.
> WITH o as (
> SELECT getRecord(1, dave.field1)
> )
> SELECT
> id, o.*
> FROM
>
Awesome, thanks that works and is quite clear. The plan looks a bit funny on
this. Any high-level synopsis on the performance of this?
From: David Johnston [mailto:pol...@yahoo.com]
Sent: Wednesday, August 15, 2012 4:57 PM
To: David Greco
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
25 matches
Mail list logo
