Thanks.
Hstore works perfectly.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jan 17, 2012, at 21:08, Tom Molesworth wrote:
> On 17/01/12 17:51, Nick wrote:
>> On Jan 17, 3:33 am, t...@audioboundary.com (Tom Molesworth) wrote:
> Looking at it again, I think the missing part is the created fields - you'll
> probably need both of those in the group by clause as well to g
> I am aware of pgpool-II and its features. Just that my requirements
> are little different. I have a System (PG runs on it) which already
> has Failover mechanism to another System and I want PG to be part of
> this cluster and not clustered on its own. Mean, PG has to be running
> in Master sys
On Wed, Jan 18, 2012 at 10:54 AM, Manoj Govindassamy
wrote:
> I am aware of pgpool-II and its features. Just that my requirements are
> little different. I have a System (PG runs on it) which already has
> Failover mechanism to another System and I want PG to be part of this
> cluster and not clu
On 17/01/12 17:51, Nick wrote:
On Jan 17, 3:33 am, t...@audioboundary.com (Tom Molesworth) wrote:
Hi Nick,
On 17/01/12 00:18, Nick wrote:
What is the most efficient way to get this result...
query_result (user_id, book_count, book_price_total, pencil_count,
pencil_price_total)
1 | 2 | $20 |
I am aware of pgpool-II and its features. Just that my requirements are
little different. I have a System (PG runs on it) which already has
Failover mechanism to another System and I want PG to be part of this
cluster and not clustered on its own. Mean, PG has to be running in
Master system an
Hi,
On 18 January 2012 11:31, David Salisbury wrote:
>
> I've got a table:
>
> Taxa
> Column |Type
> +-
> id | integer |
> parent_id | integer |
> taxonomic_ran
On Wed, Jan 18, 2012 at 6:37 AM, Manoj Govindassamy
wrote:
> (2) We are not comfortable moving to PGPool just for automatic failback mode
> on hot-standby failure.
Hmm.. my reply might be misleading. What I meant was to use pgpool-II
as a clusterware for PostgreSQL built-in replication, not as a
On Jan 17, 2012, at 19:31, David Salisbury wrote:
>
> I've got a table:
>
> Taxa
> Column |Type
> +-
> id | integer |
> parent_id | integer |
> taxonomic_ra
I've got a table:
Taxa
Column |Type
+-
id | integer |
parent_id | integer |
taxonomic_rank | character varying(32) |
latin_name | character varyi
>
> because you quickly get trapped into OS specific quicksand with these
> features.
>
Isn't that an issue with just about every feature? Besides the issues
have already been solved mostly. Pgpool already exists. Tatsuo Ishii
says porting a windows is just a resource issue as he doesn't have the
Thanks for your views.
(1) Will try out emptying synchronous_standby_names on replica failures
and verify if the transactions proceeds thru.
(2) We are not comfortable moving to PGPool just for automatic failback
mode on hot-standby failure. Any suggestions on how to build this
failback mech
On 01/17/12 12:33 PM, Tim Uckun wrote:
I think I am probably going to explore this option first. I don't
know why automatic failover, failback, etc are not built in already. I
guess even connection pooling ought to be built in. Seems like
everybody would need that no?
because you quickly get
On Tue, Jan 17, 2012 at 1:25 PM, Tim Uckun wrote:
>> Only a single-master. If you want a multi-master solution, see Postgres-XC.
>>
>
> Is postgres XC production ready? Can I trust my most valuable data to it?
The only way to know is to test it yourself. But at least a sales rep
from "Big Databa
>
> I have a few clusters running on EC2 using DRBD to replicate between
> availability zones. It's not fast, but it works. If your write load is under
> 30MB/sec it's definitely an option. I run DRBD over SSH tunnels to get around
> the random IP address issue. I use heartbeat on top for resource
> Only a single-master. If you want a multi-master solution, see Postgres-XC.
>
Is postgres XC production ready? Can I trust my most valuable data to it?
Cheers.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 01/17/12 12:10 PM, Jerry Richards wrote:
I know PostgreSQL version 9.1 supports built-in streaming
replication. Just wondering if that supports only a single-master or
also multi-master implementation?
master -> readonly slave only.
Master-Master replication is a giant can of worms,
I know PostgreSQL version 9.1 supports built-in streaming replication. Just
wondering if that supports only a single-master or also multi-master
implementation?
Thanks,
Jerry
Sample disclaimer text
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Nick
Sent: Tuesday, January 17, 2012 12:59 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Whats the most efficient query for this result?
On Jan 17, 3:33 am, t..
On Jan 17, 3:33 am, t...@audioboundary.com (Tom Molesworth) wrote:
> Hi Nick,
>
> On 17/01/12 00:18, Nick wrote:
>
>
>
>
>
>
>
>
>
> > I have three tables (users, books, pencils) and would like to get a
> > list of all users with a count and total price of their books and
> > pencils for 2012-01-01
On Jan 17, 3:33 am, t...@audioboundary.com (Tom Molesworth) wrote:
> Hi Nick,
>
> On 17/01/12 00:18, Nick wrote:
>
>
>
>
>
>
>
>
>
> > I have three tables (users, books, pencils) and would like to get a
> > list of all users with a count and total price of their books and
> > pencils for 2012-01-01
On Jan 17, 3:33 am, t...@audioboundary.com (Tom Molesworth) wrote:
> Hi Nick,
>
> On 17/01/12 00:18, Nick wrote:
>
>
>
>
>
>
>
>
>
> > I have three tables (users, books, pencils) and would like to get a
> > list of all users with a count and total price of their books and
> > pencils for 2012-01-01
Thanks! I'd missed that part apparently :(
Regards,
Jeroen
Op 17 jan. 2012 om 17:40 heeft Adrian Klaver het
volgende geschreven:
> On Tuesday, January 17, 2012 8:27:19 am Jeroen van Dongen wrote:
>> Hi,
>>
>> In a current project I've a PL/Python function that uses default
>> parameters, like
On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
wrote:
> I know PostgreSQL version 9.1 supports built-in streaming replication.
> Just wondering if that supports only a single-master or also multi-master
> implementation?
Only a single-master. If you want a multi-master solution, see Postgres-XC
I know PostgreSQL version 9.1 supports built-in streaming replication. Just
wondering if that supports only a single-master or also multi-master
implementation?
Thanks,
Jerry
Sample disclaimer text
PostgreSQL Day will take place on Friday 20 January at the LAX Hilton as
part of the special events of the Southern California Linux Expo (SCALE10X).
If you are in the area please join us for a day of great talks on
Friday, and all weekend at the PostgreSQL booth in the Expo Hall.
For more detail
On Tuesday, January 17, 2012 8:27:19 am Jeroen van Dongen wrote:
> Hi,
>
> In a current project I've a PL/Python function that uses default
> parameters, like this:
>
> CREATE FUNCTION auth.create_user(
> email text,
> initial_password text,
> display_name text DEFAULT NULL,
> mob
Hi guys,
i'm currently in the process of upgrading my 8.4SS version to a 9.1 version
of postgresql.
I am running it on a Windows 2003 Server machine.
The tool that I'm using is 'pg_upgrade'.
Both servers are stopped.
I have editet the pgpass.conf to include a line like this:
'*:*:*:postgres:postg
Ok ive come a little further.
I changed the user to the administrator and now my output looks like this.
D:\Program Files\PostgreSQL\9.1\bin>pg_upgrade -d "D:/Program
Files/PostgresPlus
/8.4SS/data" -D "D:/Program Files/PostgreSQL/9.1/data" -b "D:/Program
Files/Post
gresPlus/8.4SS/bin" -B "D:/Pro
Hi,
In a current project I've a PL/Python function that uses default
parameters, like this:
CREATE FUNCTION auth.create_user(
email text,
initial_password text,
display_name text DEFAULT NULL,
mobile_phone text DEFAULT NULL,
status auth.enum_user_status DEFAULT 'active'
) RETU
Michael Tefft writes:
> I would like to extract the DDL to create a given object (tables, primarily)
> from the catalog. Is there an interface, query, etc. that will do this? I'd
> rather not craft the DDL myself.
DDL isn't actually stored in the catalogs anywhere; it has to be
reconstructed.
On 17/01/2012 12:58, Tefft, Michael J wrote:
> Any suggestions for doing this from PL/pgSQL?
If you run psql with the -E option, and then do various \d commands to
examine database objects, it will output the queries it generates to get
metadata - you can then adapt these to your own needs.
Ray.
Hi there
I have installed pgAgent (scheduling) in the default "postres" database on
my server. I read somewhere that this is where the linux pgAgent expects to
find its tables.
My own application database is called "xyz" on the same server.
Now I need to create pgAgent "jobs" from my "xyz" stored
Any suggestions for doing this from PL/pgSQL?
-Original Message-
From: dep...@depesz.com [mailto:dep...@depesz.com]
Sent: Tuesday, January 17, 2012 6:25 AM
To: Tefft, Michael J
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?
On Tue, Jan 1
Hi Nick,
On 17/01/12 00:18, Nick wrote:
I have three tables (users, books, pencils) and would like to get a
list of all users with a count and total price of their books and
pencils for 2012-01-01...
So with this data...
users (user_id)
1
2
3
books (user_id, price, created)
1 | $10 | 2012-01-
On Tue, Jan 17, 2012 at 04:53:42AM -0600, Tefft, Michael J wrote:
> I would like to extract the DDL to create a given object (tables,
> primarily) from the catalog. Is there an interface, query, etc. that
> will do this? I'd rather not craft the DDL myself.
use pg_dump -t table_name -s
Best rega
I have three tables (users, books, pencils) and would like to get a
list of all users with a count and total price of their books and
pencils for 2012-01-01...
So with this data...
users (user_id)
1
2
3
books (user_id, price, created)
1 | $10 | 2012-01-01
1 | $10 | 2012-01-01
3 | $10 | 2012-01-0
I would like to extract the DDL to create a given object (tables, primarily)
from the catalog. Is there an interface, query, etc. that will do this? I'd
rather not craft the DDL myself.
Thanks,
Mike
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> http://www.drbd.org/ ??
> Built in hot standby and hand rolled scripts.
>
I have a few clusters running on EC2 using DRBD to replicate between
availability zones. It's not fast, but it works. If your write load is under
30MB/sec it's d
I would like to extract the DDL to create a given object (tables, primarily)
from the catalog. Is there an interface, query, etc. that will do this? I'd
rather not craft the DDL myself.
Thanks,
Mike
>
>
> That's true, but they are more concerned with the live/deleted status of
> tuples and not the logical content... Perhaps generating statements is the
> key for now...
>
Creating a function that takes tid[] as a parameter works the way I want it
to :)
--
Eld på åren og sol på eng gjer manne
On Mon, Jan 16, 2012 at 5:31 PM, Tomas Vondra wrote:
> What about pgstattuple?
>
> http://www.postgresql.org/docs/9.1/interactive/pgstattuple.html
>
> Maybe it already does what you're trying to implement ...
>
> Look at pageinspect module too
>
> http://www.postgresql.org/docs/9.1/interactive/pa
Eureka!
I changed 127.0.0.1 for the PG's assiged IP address 192.168. and now it
works :)
Thx & cheers,
P.
2012/1/16 Tom Lane
> "P. Broennimann" writes:
> > -> The problem I am having is that I can not start pgagent. When I try:
>
> > cd /usr/bin
> > ./pgagent hostaddr=127.0.0.1 port=543
43 matches
Mail list logo
