Hi,
Is it possible to configure postgres from SQL?
I am interested in turning off fsync for a set of queries (that take
ages to run) and then turn fsync back on again afterwards.
Cheers,
Tom
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 12 July 2010 14:29, Tom Wilcox hungry...@gmail.com wrote:
Hi,
Is it possible to configure postgres from SQL?
I am interested in turning off fsync for a set of queries (that take ages to
run) and then turn fsync back on again afterwards.
Cheers,
Tom
You can only change that option in
Hi,
Is it possible to configure postgres from SQL?
I am interested in turning off fsync for a set of queries (that take
ages to run) and then turn fsync back on again afterwards.
There are things that can be changed at runtime using SQL - in that case
you may just type SET enable_seqscan =
On 12 July 2010 14:50, Tom Wilcox hungry...@gmail.com wrote:
Hi Thom,
I am performing update statements that are applied to a single table that is
about 96GB in size. These updates are grouped together in a single
transaction. This transaction runs until the machine runs out of disk space.
On Monday 12 July 2010 6:29:14 am Tom Wilcox wrote:
Hi,
Is it possible to configure postgres from SQL?
Yes to a degree, see here:
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html
I am interested in turning off fsync for a set of queries (that take
ages to run) and then
Hi Thom,
Yeah They can be divided up, but my main issue is that I would like
these functions wrapped up so that the client (who has little to no
experience using PostgreSQL) can just run a SQL function that will
execute all of these updates and prepare many tables and functions for a
Le 12/07/2010 17:02, Tom Wilcox a écrit :
Hi Thom,
Yeah They can be divided up, but my main issue is that I would like
these functions wrapped up so that the client (who has little to no
experience using PostgreSQL) can just run a SQL function that will
execute all of these updates and
On Monday 12 July 2010 15:29:14 Tom Wilcox wrote:
Hi,
Is it possible to configure postgres from SQL?
I am interested in turning off fsync for a set of queries (that take
ages to run) and then turn fsync back on again afterwards.
disabling fsync is nearly never a good idea.
What you can
On Mon, 2010-07-12 at 14:57 +0100, Thom Brown wrote:
On 12 July 2010 14:50, Tom Wilcox hungry...@gmail.com wrote:
Hi Thom,
I am performing update statements that are applied to a single table that is
about 96GB in size. These updates are grouped together in a single
transaction. This
On Mon, Jul 12, 2010 at 7:57 AM, Thom Brown thombr...@gmail.com wrote:
On 12 July 2010 14:50, Tom Wilcox hungry...@gmail.com wrote:
Hi Thom,
I am performing update statements that are applied to a single table that is
about 96GB in size. These updates are grouped together in a single
Andres Freund wrote:
What you can change (and that makes quite a bit of sense in some situations)
is the synchronous_commit setting.
Right. In almost every case where people think they want to disable
fsync, what they really should be doing instead is turning off
synchronous
I could perform the settings manually (set config, restart svr, execute
script, come back 2 days later, reset config, restart svr, execute more
script,...), but that sort of defeats the point. My aim to have the
simplest, automatic setup possible. Preferably completely contained
within
Please don't top post.
On Mon, Jul 12, 2010 at 2:20 PM, Tom Wilcox hungry...@gmail.com wrote:
On 12/07/2010 19:26, Scott Marlowe wrote:
On Mon, Jul 12, 2010 at 7:57 AM, Thom Brownthombr...@gmail.com wrote:
On 12 July 2010 14:50, Tom Wilcoxhungry...@gmail.com wrote:
Hi Thom,
I am
We are having a very strange issue where for certain records, queries
sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We
are running 8.3.9.
We found our problem. It turned out to be a config file that was
On 09/07/10 21:36, Tyler Hains wrote:
We are having a very strange issue where for certain records, queries
sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We
are running 8.3.9.
We found our problem. It
We are having a very strange issue where for certain records, queries
sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We
are running 8.3.9.
SELECT client_id FROM locations WHERE external_id = '278';
On 9/07/2010 5:24 AM, Tyler Hains wrote:
We are having a very strange issue where for certain records, queries
sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We
are running 8.3.9.
Can you post a
Thanks Craig.
I still find it a bit awkward that we have to use priv check function-s
because we can't define triggers on or reference to system tables. I think
that allowing it would significantly extend Postgres possibilities.
From a quick google it seems that triggers on system tables is
On 06/07/10 17:47, Davor J. wrote:
Thanks Craig.
I still find it a bit awkward that we have to use priv check function-s
because we can't define triggers on or reference to system tables. I think
that allowing it would significantly extend Postgres possibilities.
Certainly being able to
Several times I wanted to extend some of the postgres objects, like roles
or functions. For example, sometimes you want to add extra attributes to
roles, which are application dependent. Or sometimes you want to store
functions and reference them in your custom tables, without losing
On 04/07/10 21:43, Davor J. wrote:
PS using inheritance in this scenario is problematic.
Yep. Just one issue is that roles are cluster-wide, whereas tables are
visible only inside a single database.
I generally use the role mechanism as-is, granting users access to roles
that control
On 21/05/2010 9:43 PM, christophe.an...@elsys-design.com wrote:
Hi,
How I know whether Postgres is already installed or not on a machine(on
Linux and Windows)?
I found that pg_ctl --version could be used
Only if PostgreSQL's binary directory is on the PATH, which it may not
be especially on
Hi,
How I know whether Postgres is already installed or not on a machine(on
Linux and Windows)?
I found that pg_ctl --version could be used or I also tried to check into
the registry (for windows HKLM\SOFTWARE\PostgreSQL\Installations), however
with Windows Server 2003 pg_ctl is not recognized
What about searching your hard drive for pg_ctl.exe?
RobR
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 21/05/2010 14:43, christophe.an...@elsys-design.com wrote:
How I know whether Postgres is already installed or not on a machine(on
Linux and Windows)?
I found that pg_ctl --version could be used or I also tried to check into
the registry (for windows
John R Pierce wrote:
Ognjen Blagojevic wrote:
Is there a way to run Postgres in embedded mode? More precisely, to
run it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it
Ognjen,
Is there a way to run Postgres in embedded mode? More precisely, to run it
without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it can be run with unix domain sockets,
John R Pierce wrote:
Ognjen Blagojevic wrote:
Is there a way to run Postgres in embedded mode? More precisely, to
run it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it
Massa, Harald Armin wrote:
on unix, as you imply, it can be run with unix domain sockets,
but not on Windows as they simply don't have this interface.
and, it can be started as an application rather than as a
system service, but it still runs as a separate
Hi,
Is there a way to run Postgres in embedded mode? More precisely, to run
it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
-Ognjen
--
Sent via pgsql-general mailing list
Ognjen Blagojevic ogn...@etf.bg.ac.rs writes:
Is there a way to run Postgres in embedded mode? More precisely, to run
it without using TCP/IP port, and without installing as a service?
No.
regards, tom lane
--
Sent via pgsql-general mailing list
Ognjen Blagojevic, 21.04.2010 17:08:
More precisely, to run it without using TCP/IP port
No
and without installing as a service?
Yes (simply run pg_ctl manually from the command line)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Ognjen Blagojevic wrote:
Is there a way to run Postgres in embedded mode? More precisely, to
run it without using TCP/IP port, and without installing as a service?
I am aware of Unix-domain sockets, but is there something similar for
Windows?
on unix, as you imply, it can be run with unix
List, we need to run v8.1.11 but can not find the binaries for RedHat
Enterprise Linux 5 (CentOs 5). The sources are at
ftp://ftp-archives.postgresql.org/pub/source/ but we rather install it from the
binaries. Can you point to someplace we can get them? Already tried
rpmfind.net,
Maurício Ramos wrote:
List, we need to run v8.1.11 but can not find the binaries for RedHat
Enterprise Linux 5 (CentOs 5).
It's unlikely you specifically need 8.1.11; a later 8.1 should work
fine. See http://www.postgresql.org/support/versioning for details
about what changes between
My hba file has:
local all postgresmd5
hostall admin 127.0.0.1/32 md5
hostall dbuser127.0.0.1/32 md5
But that still allows users other than postgres to attempt to login as
postgres. Is there
gvim wrote:
My hba file has:
local all postgresmd5
hostall admin 127.0.0.1/32 md5
hostall dbuser127.0.0.1/32 md5
But that still allows users other than postgres to attempt to login as
On 1 April 2010 09:13, Dave Page dp...@postgresql.org wrote:
Following a great deal of discussion, I'm pleased to announce that the
PostgreSQL Core team has decided that the major theme for the 9.1
release, due in 2011, will be 'NoSQL'.
There is a growing trend towards NoSQL databases, with
On Thu, Apr 1, 2010 at 9:30 AM, Thom Brown thombr...@gmail.com wrote:
I prefer to dump all my data in a big text file and grep it for the
information I need.
There's no need to start showing off and get all technical y'know.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent
Ciao Dave,
You may also notice that without SQL, the project name is somewhat
misleading. To address that, the project name will be changed to
'PostgreQUEL' with the 9.1 release. We expect this will also put an
end to the periodic debates on changing the project name.
Ahahahah ... nice fish!
Nice to hear and thumbs up! I've just start planning to migrate one of
my telco 3Tb database running blunt oracle to coachDb but now of
course postgres looks better. Hopefully stupid transactions will be
abrogated to
wbr Ilya
On Thu, Apr 1, 2010 at 12:33 PM, Dave Page dp...@postgresql.org
2010/4/1 Thom Brown thombr...@gmail.com:
On 1 April 2010 09:13, Dave Page dp...@postgresql.org wrote:
Following a great deal of discussion, I'm pleased to announce that the
PostgreSQL Core team has decided that the major theme for the 9.1
release, due in 2011, will be 'NoSQL'.
There is a
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the
information I need.
As long as you implement your own grep, that sounds about on par with
the current trends! Go for it!
Well, first you have to implement your own
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler da...@kineticode.com wrote:
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the
information I need.
As long as you implement your own grep, that sounds about on par with
the
On Thu, 2010-04-01 at 10:54 -0600, Scott Marlowe wrote:
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler da...@kineticode.com
wrote:
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the
information I need.
As long
On 04/01/2010 09:54 AM, Scott Marlowe wrote:
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheelerda...@kineticode.com wrote:
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the information
I need.
As long as you implement
Hi,
Could anyone please suggest me how to deal with my following requirements.
So far, I have done following to meet my requirements:
*
I want users to use only stored procedures to create, alter, delete tables
in mydb schema*. == For this, I have *revoked all permissions from
mydb *schema,
and
Howdy;
We have written an application that uses PG as the backend database.
We currently embed the database servers IP address in a text file that
the installed (created using Inno) uses when setting up the client
programs (ie, stores this info in a local .ini file).
Is there a recommended way of
Lookup bonjour support in postgres server docs.
On Tue, Mar 9, 2010 at 4:17 PM, imageguy imageguy1...@gmail.com wrote:
Is there a recommended way of discovery a PG server on the network ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 23/01/2010 3:31 PM, Grzegorz Jaśkiewicz wrote:
On Fri, Jan 22, 2010 at 7:15 PM, Erik Jonesejo...@engineyard.com wrote:
Hello,
Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly
likely that there may be a number of people and companies looking to move from
2010/1/23 Craig Ringer cr...@postnewspapers.com.au:
An InnoDB `AUTO_INCREMENT' column under MySQL 5.x is pretty similar to a
sequence.
I increasingly think it's pretty safe to just
's/AUTO_INCREMENT/SERIAL/g'
in DDL. Apps that use MyISAM aren't going to be fussy about how it works,
and
On Fri, 2010-01-22 at 11:15 -0800, Erik Jones wrote:
Does anyone know of any good, current migration tools out there?
There is an open source tool developed by EnterpriseDB: MigrationWizard
Hello,
Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly
likely that there may be a number of people and companies looking to move from
MySQL to Postgres in the coming months. Does anyone know of any good, current
migration tools out there? A search for mysql on
Hi,
I googled for 'migrate mysql to postgresql' the first 5 results seem
very useful.
The most useful link I found was http://www.raditha.com/mysql/mysql2pgsql.php
HTH
Regards,
Serge Fonville
On Fri, Jan 22, 2010 at 8:15 PM, Erik Jones ejo...@engineyard.com wrote:
Hello,
Given that the EU
On Fri, Jan 22, 2010 at 7:15 PM, Erik Jones ejo...@engineyard.com wrote:
Hello,
Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's
fairly likely that there may be a number of people and companies looking to
move from MySQL to Postgres in the coming months. Does anyone
I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
import java.sql.*;
public static void main(String[] args) {
// TODO code application logic here
try{
System.out.println(Starting...);
Dave Coventry wrote:
I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
does that sample code hang? do you get an error?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Dave,
It looks like the postgresql.jar archive is not in your CLASSPATH.
[]s, Fernando Lozano
I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
import java.sql.*;
public static void main(String[] args) {
// TODO
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
Anyway you cen find more help about jdbc connectivity to postgres here:
http://jdbc.postgresql.org/
Dave Coventry ha scritto:
I'm not sure this is the right place to enquire...
I'm trying to connect to a
Ivano Luberti wrote:
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
say huh?
http://jdbc.postgresql.org/documentation/84/load.html
http://jdbc.postgresql.org/documentation/84/connect.html
says what he's doing is fine.
--
Sent via pgsql-general
Oh sorry, cut and paste mistake
By the way using that syntax he is using he is assuming the server is
running on localhost and the port is the default one
John R Pierce ha scritto:
Ivano Luberti wrote:
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
Hi,
postgres cores on SUN 2.9. Disk is in 100% IO.
(dbx) where
[1] 0x65eacdd4(0x7fffa36c, 0x400, 0x10032d4e8, 0x1, 0x48,
0xd6), at 0x65eacdd4
[2] XLogFileInit(0x48, 0xd6, 0x7fffa85d, 0x1, 0x488000, 0x0), at
0x10007955c
[3] XLogWrite(0x48, 0x6, 0x1,
Dear all,
I am using the archive binary(8.4.1 Linux x64) from
EnterpriseDBhttp://www.enterprisedb.com/products/pgbindownload.dofor
the installation. Basically I just unzipping the binary under
/home/app/, so i have the following directory structure
/home/app/pgsql
I noticed that i need to
is postgres a good solution for billion record data, think of 300kb data
insert into db at each minutes, I'm coding with php
what do you recommend to manage these data?
--
Shahrzad Khorrami
In addition to this what about MySQL, how much data (records) that can be
managed with it?
regards
On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami
shahrzad.khorr...@gmail.com wrote:
is postgres a good solution for billion record data, think of 300kb data
insert into db at each minutes,
On 24/10/2009 20:46, Tawita Tererei wrote:
In addition to this what about MySQL, how much data (records) that can be
managed with it?
regards
On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami
shahrzad.khorr...@gmail.com wrote:
is postgres a good solution for billion record data,
On Sat, Oct 24, 2009 at 1:46 PM, Tawita Tererei nevita0...@hotmail.com wrote:
In addition to this what about MySQL, how much data (records) that can be
managed with it?
That's a question for the mysql mailing lists / forums really. I do
know there's some artificial limit in the low billions
On Sat, Oct 24, 2009 at 7:32 AM, shahrzad khorrami
shahrzad.khorr...@gmail.com wrote:
is postgres a good solution for billion record data, think of 300kb data
insert into db at each minutes, I'm coding with php
what do you recommend to manage these data?
You'll want a server with LOTS of hard
On Sat, Oct 24, 2009 at 2:43 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Sat, Oct 24, 2009 at 7:32 AM, shahrzad khorrami
shahrzad.khorr...@gmail.com wrote:
is postgres a good solution for billion record data, think of 300kb data
insert into db at each minutes, I'm coding with php
what
Raymond O'Donnell wrote:
On 24/10/2009 20:46, Tawita Tererei wrote:
In addition to this what about MySQL, how much data (records) that can be
managed with it?
regards
On Sun, Oct 25, 2009 at 3:32 AM, shahrzad khorrami
shahrzad.khorr...@gmail.com wrote:
is postgres a good solution for
Zdenek Kotala wrote:
John R Pierce píše v út 15. 09. 2009 v 19:53 -0700:
anyone on the PG team privvy to Sun Solaris patches for postgres? like
patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is
the same for Sol10 x86...
What is wrong on this? It is standard
John R Pierce píše v út 15. 09. 2009 v 19:53 -0700:
anyone on the PG team privvy to Sun Solaris patches for postgres? like
patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is
the same for Sol10 x86...
What is wrong on this? It is standard Solaris way how to deliver
John R Pierce píše v so 26. 09. 2009 v 09:44 -0700:
I'm curious if anyone has a clue how long before Sun releases PG 8.4.x
in Solaris 'patch' format ...
Currently S10 is shipped with three version (8.1, 8.2, 8.3) of
PostgreSQL. There is no plan to integrate PG8.4 into S10 at
Zdenek Kotala wrote:
I asked because we're working on an inhouse app using postgres, the team
wants to use 8.4... I had previously packaged 8.3.7 in solaris package
format only to have it come out as a patch a month or two later, so I
was hoping to save myself the redundant effort.
John R Pierce píše v so 26. 09. 2009 v 10:57 -0700:
Zdenek Kotala wrote:
I asked because we're working on an inhouse app using postgres, the team
wants to use 8.4... I had previously packaged 8.3.7 in solaris package
format only to have it come out as a patch a month or two later, so I
anyone on the PG team privvy to Sun Solaris patches for postgres? like
patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is
the same for Sol10 x86...
I'm curious if anyone has a clue how long before Sun releases PG 8.4.x
in Solaris 'patch' format ...
--
Sent via
n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Fri, 10 Jul 2009 21:56:09 -0500
Subject: Re: [GENERAL] Using Postgres to store
We're looking at potentially using Postgres to store a variety of molecular
and genetic data. At this point I have a bunch of general questions which I
can take to other lists if someone can tell me where
they would be most appropriate:
1) are there groups or individuals already doing this that
Peter Hunsberger wrote:
We're looking at potentially using Postgres to store a variety of
molecular and genetic data. At this point I have a bunch of general
questions...
I don't know enough about your area of expertise to know if this is
useful, but I'd look at the Unison project to see
On Fri, Jul 10, 2009 at 4:02 PM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
Peter Hunsberger wrote:
We're looking at potentially using Postgres to store a variety of molecular
and genetic data. At this point I have a bunch of general questions...
I don't know enough about your
2009/5/28 Eddy Ernesto Baños Fernández eeba...@estudiantes.uci.cu:
Try Cybercluster
I looked into that. There is one piece of documentation that is less
than ten pages long. There is no users group, no listserve, no
community that I can discern.
Do you have experience with it and if so
Hello,
I am wondering if anyone has successfully compiled postgres for 64 bit windows
using mingw64? I tried doing so but the configure step fails with the
following message:
conftest.c:50: error: conflicting types for 'accept'
The config.log file shows the following additional message:
McWilliams, Steven steven_mcwilli...@bmc.com writes:
I am wondering if anyone has successfully compiled postgres for 64 bit
windows using mingw64?
We don't currently support 64-bit builds on Windows. There are a pile
of issues there, most coming from Microsoft's nonstandard decision to
make
Hi CMJ,
If you are using WebNMS framework with hibernate, can you check if you have
done this:
*ConfigReader configReader = ConfigReader.getInstance();
configReader.modifyHbmToDdl(true);
*
Thanks,
Saurabh
On Wed, Jun 24, 2009 at 6:06 PM, CM J postgres.new...@gmail.com
Hi,
The problem turned out to be not with postgres but my JDBC connection
code.
Thanks !
On Thu, Jun 25, 2009 at 5:25 PM, Saurabh Dave saurabhd...@gmail.com wrote:
Hi CMJ,
If you are using WebNMS framework with hibernate, can you check if you have
done this:
*
On Wed, May 27, 2009 at 1:57 PM, Alan McKay alan.mc...@gmail.com wrote:
Hey folks,
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on
Alan,
here I'm implementing something similar to the Chord protocol [1] on the
application level to partition my data across 6 PostgreSQL servers with N+1
replication. Two up sides on this approch:
1 - When one server is down the load is spread between all the other ones,
instead of going only
Try Cybercluster
-Mensaje original-
De: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] En nombre de Alan McKay
Enviado el: miércoles, 27 de mayo de 2009 13:57
Para: pgsql-performa...@postgresql.org; pgsql-general@postgresql.org
Asunto: [PERFORM]
On Wednesday 27 May 2009 12:55:51 Eddy Ernesto Baños Fernández wrote:
Try Cybercluster
-Mensaje original-
De: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] En nombre de Alan McKay
Enviado el: miércoles, 27 de mayo de 2009 13:57
Para:
Continuent works (AFAIK) like pgpool clustering, it sends the same
statements to both/all servers in the cluster but it has no insight to the
servers beyond this, so if via a direct connection server A becomes out of
sync with server B then continuent is oblivious.
So can the same be said for
On Wednesday 27 May 2009 13:33:55 Alan McKay wrote:
Continuent works (AFAIK) like pgpool clustering, it sends the same
statements to both/all servers in the cluster but it has no insight to
the servers beyond this, so if via a direct connection server A becomes
out of sync with server B
Hi,
Le 27 mai 09 à 19:57, Alan McKay a écrit :
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on PostgreSQL clustering? What options are
Depending on your exact needs, which the terminology you're using only allow
to guess about, you might enjoy this reading:
http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf
Thanks. To be honest I don't even know myself what my needs are yet.
I've only been on the job here for a
Is there any kind of a parallel psql client, to control a cluster of
databases, without the need to write a plproxy function for each request?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Mon, 23 Mar 2009 15:03:15 +1100
Greenhorn user.postgre...@gmail.com wrote:
Hi,
I'm trying to pass variables on a bash script embedded with psql
commands.
cat header.txt
to1,from1,subject1
to2,from2,subject2
to3,from3,subject3
to4,from4,subject4
cat b.sh
#!/bin/bash
two=2
Hi,
I'm trying to pass variables on a bash script embedded with psql commands.
cat header.txt
to1,from1,subject1
to2,from2,subject2
to3,from3,subject3
to4,from4,subject4
cat b.sh
#!/bin/bash
two=2
psql -h localhost -U postgres -d mobile -c create temp table header (
field_1 textnot
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]on Behalf Of Greenhorn
Sent: Monday, 23 March 2009 3:03 PM
To: pgsql-general@postgresql.org; pgsql-...@postgresql.org
Subject: [GENERAL] bash postgres
Hi,
I'm trying
Quoth Kusuma Pabba kusu...@ncoretech.com:
/usr/local/pgsql/bin/psql test
test=#
sudo su postgres -c psql template1
template=#
why is the path different in both cases?
Type:
$ which psql
and
$ sudo which psql
The answer is the same, yes?
$ /usr/local/pgsql/bin/psql test
On Thu, Feb 05, 2009 at 08:12:48AM +, Sebastian Tennant wrote:
This is why you need to type 'sudo su postgres -c psql template1'.
A little shortcut, you can do the above from sudo as:
sudo -u postgres psql template1
This was pointed out to me by another kind soul on this list, but I
On Thu, Feb 05, 2009 at 12:05:31PM +0530, Kusuma Pabba wrote:
how can i create a user in test or template
when i give create user
it is asking for create role , how should i create role?
Users are associated with the cluster and not with any specific
database. I tend to add users by directly
401 - 500 of 1052 matches
Mail list logo