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 t...@sss.pgh.pa.us
P. Broennimann peter.broennim...@gmail.com writes:
- The problem I am having is that I can not start pgagent. When I try:
cd /usr/bin
On Mon, Jan 16, 2012 at 5:31 PM, Tomas Vondra t...@fuzzy.cz 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
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 mannen
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
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
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
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 |
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
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 |
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
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
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.
Michael Tefft mjte...@hotmail.com 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
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'
)
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\binpg_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:/Program
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:
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,
mobile_phone
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
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
On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
jerry.richa...@teotech.com 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
Thanks! I'd missed that part apparently :(
Regards,
Jeroen
Op 17 jan. 2012 om 17:40 heeft Adrian Klaver adrian.kla...@gmail.com 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
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...
So with
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...
So with
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...
So with
-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,
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
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,
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:
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
On Tue, Jan 17, 2012 at 1:25 PM, Tim Uckun timuc...@gmail.com 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
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
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
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
I've got a table:
Taxa
Column |Type
+-
id | integer |
parent_id | integer |
taxonomic_rank | character varying(32) |
latin_name | character
On Jan 17, 2012, at 19:31, David Salisbury salisb...@globe.gov wrote:
I've got a table:
Taxa
Column |Type
+-
id | integer |
parent_id | integer |
On Wed, Jan 18, 2012 at 6:37 AM, Manoj Govindassamy
ma...@nimblestorage.com 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
Hi,
On 18 January 2012 11:31, David Salisbury salisb...@globe.gov wrote:
I've got a table:
Taxa
Column |Type
+-
id | integer |
parent_id | integer |
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
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 |
On Wed, Jan 18, 2012 at 10:54 AM, Manoj Govindassamy
ma...@nimblestorage.com 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
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
On Jan 17, 2012, at 21:08, Tom Molesworth t...@audioboundary.com 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
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
43 matches
Mail list logo