hi all,
has anyone here heard of / used:
http://pgfoundry.org/projects/edb-debugger/
This allows one to debug code, using breakpoints, single stepping etc. which
seems really great but I haven't figured out how to use it yet?
I can't figure out how to invocate the server (target) side in order
Jason Long wrote:
I am planning on setting up PITR for my application.
I also have to ship them off site using a T1 so setting the time to
automatically switch files will just waste bandwidth if they are still
going to be 16 MB anyway.
*1. What is the effect of recompiling and reducing the
On Tue, Oct 28, 2008 at 11:36:12PM -0300, x asasaxax wrote:
> table_1: product_code, atualization_date
> table_2: id, date, value
> I need to get the value of table 2 that has the greatest date that is minor
> that atualization_date.
> The select should return something like that:
> unique product_
On Tue, Oct 28, 2008 at 7:10 PM, Christophe <[EMAIL PROTECTED]> wrote:
>
> On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote:
>>
>> Installing from source means I can avoid the fragility of macports or
>> fink, and know that I've built it in much the same way as the postgresql or
>> solaris installat
Hi everyone,
I have two tables:
table_1: product_code, atualization_date
table_2: id, date, value
I need to get the value of table 2 that has the greatest date that is minor
that atualization_date.
The select should return something like that:
unique product_code´s, with their atualization_d
I am planning on setting up PITR for my application.
It does not see much traffic and it looks like the 16 MB log files
switch about every 4 hours or so during business hours.
I am also about to roll out functionality to store documents in a bytea
column. This should make the logs roll faster.
Niklas Johansson wrote:
On 28 okt 2008, at 23.41, Tom Allison wrote:
I was using macports but got into a cluster-F on versions and multiple
installs. After a spell I had all four versions 8.0 - 8.3 installed
in order to use postgres, ruby, perl, and rails together.
Do you mean that Macports
Bruce McAlister <[EMAIL PROTECTED]> writes:
> In addition to the missing configure option, it turned out to be missing
> LDFLAGS parameters, I just added -L/usr/lib to LDFLAGS and it all built
> successfully now.
Bizarre ... I've never heard of a Unix system that didn't consider that
a default pla
>
> The 1.6.2 stable version which you use is right.
>
Thanks, we managed to get it working now. Thanks for the pointers.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>
> Huh. Nothing obvious in your info about why it wouldn't work. I think
> you'll need to dig through the config.log output to see why these link
> tests are failing. (They'll be a few hundred lines above the end of the
> log, because the last part of the log is always a dump of configure's
>
Do I need to use a specific version of the ossp-uuid libraries for this
module?
The 1.6.2 stable version which you use is right.
Regards,
Hiroshi Saito
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Bruce McAlister <[EMAIL PROTECTED]> writes:
> When I run configure with the above options, I end up with the following
> configure error:
> checking for uuid_export in -lossp-uuid... no
> checking for uuid_export in -luuid... no
> configure: error: library 'ossp-uuid' or 'uuid' is required for OSS
Hi.
Um, you are reconfigure of postgresql then. It is necessary to specify
with-ossp-uuid.
Regards,
Hiroshi Saito
- Original Message -
From: "Bruce McAlister" <[EMAIL PROTECTED]>
To: "pgsql"
Sent: Wednesday, October 29, 2008 8:01 AM
Subject: [GENERAL] UUID-OSSP Contrib Module Compi
>
> Um ... did you run PG's configure script with --with-ossp-uuid?
> It looks like either you didn't do that, or configure doesn't know
> to look in the place where you put the ossp-uuid header files.
>
Doh, I missed that, however, I have now included that option but it
still does not find the
Bruce McAlister <[EMAIL PROTECTED]> writes:
> I am trying to build the uuid-ossp contrib module for PostgreSQL 8.3.4.
> I am building on Solaris x86 with Sun Studio 12.
> I built the ossp-uuid version 1.6.2 libraries and installed them,
> however, whenever I attempt to build the contrib module I a
aravind chandu wrote:
I am using pqxx API for postgresql.The following is the
part of my code.The problem is in the query I am selecting the number
of rows from the table since there is only one user name and password
row it should return 1 and if there is no match then it should re
On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote:
Installing from source means I can avoid the fragility of macports
or fink, and know that I've built it in much the same way as the
postgresql or solaris installation I'd be using for production.
+1
It means I can easily pick the contrib mod
Hi All,
I am trying to build the uuid-ossp contrib module for PostgreSQL 8.3.4.
I am building on Solaris x86 with Sun Studio 12.
I built the ossp-uuid version 1.6.2 libraries and installed them,
however, whenever I attempt to build the contrib module I always end up
with the following error:
---
On 28 okt 2008, at 23.41, Tom Allison wrote:
I can get postgresql installed in three flavors:
EnterpriseDB has a dmg package for Mac.
macports has their own package.
fink also has their own package.
You also have the fourth, most delicious flavor: build it yourself;
PostgreSQL compiles nicel
On Oct 28, 2008, at 3:41 PM, Tom Allison wrote:
Relatively simple question that I hope doesn't start too much "Flame".
I have recently had the opportunity to reformat my macbook hard
drive, many thanks to suggestions from the actual Apple support
team. That's not why I'm writing to the po
Relatively simple question that I hope doesn't start too much "Flame".
I have recently had the opportunity to reformat my macbook hard drive,
many thanks to suggestions from the actual Apple support team. That's
not why I'm writing to the postgres group... But it's related.
I have a fresh
Hello,
I am using pqxx API for postgresql.The following is the part of my
code.The problem is in the query I am selecting the number of rows from the
table since there is only one user name and password row it should return 1 and
if there is no match then it should return 0.But here
Mike Toews wrote:
> This works perfectly in psql (exactly what I wanted). However, I'm most
> comfortable using PgAdminIII, and I've tried adding "SET VERBOSITY TO
> terse;" to either the first command or within the PL/pgSQL function and
> get the same error:
>
>unrecognized configuratio
Mike Toews <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> In psql, "\set VERBOSITY terse" might approximate what you want.
> Is the feature described above unique only to psql?
In that form it's psql-specific. I dunno whether pgAdmin has something
comparable ... you might try asking on their m
Tom Lane wrote:
In psql, "\set VERBOSITY terse" might approximate what you want.
This works perfectly in psql (exactly what I wanted). However, I'm most
comfortable using PgAdminIII, and I've tried adding "SET VERBOSITY TO
terse;" to either the first command or within the PL/pgSQL function
On 27 Paź, 13:16, [EMAIL PROTECTED] (Sam Mason) wrote:
> On Mon, Oct 27, 2008 at 01:59:42AM -0700, wstrzalka wrote:
> > I'm using psql mainly in putty window.
>
> it's pretty much always just worked with me. I'm using a very old
> version of putty, but it all hangs together as well as anything els
Mike Toews <[EMAIL PROTECTED]> writes:
> My question is if there is any way to quiet the context messages (i.e.,
> reduce the verbosity)? Could this be done by setting a parameter?
In psql, "\set VERBOSITY terse" might approximate what you want.
regards, tom lane
--
Sen
Hi all,
I'm in the process of debugging some PL/pgSQL functions. I have function
A which calls function B (e.g. on Line 22). The debugging info I'm
interested in is in function B, but I call function A (since there are
other C, D, F functions called from A). However, what I see is really
dist
Allan Kamau wrote:
Reid Thompson wrote:
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough
to use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated
below (see )when I run this command I get the following
https://www-927.ibm.com/ibm/cas/cascon/papers/papers.shtml#1
Tuesday, October 28 paper presentations
Session 1: Databases
DBMS Workload Control Using Throttling: Experimental Insights
Best Paper
Wendy Powley and Pat Martin, Queen's University; Paul Bird, IBM Toronto Lab
"Today's Database Managem
On Tue, Oct 28, 2008 at 03:11:05PM +0200, Allan Kamau wrote:
> Sam, I have been unable to understand your shell script well enough to
> use it. Seems am slow this afternoon :-)
Don't worry, I've just spent an hour going through three computers
trying to figure out why they didn't work. In the en
Thanks Tom,
The "n" has always been small, like 20, or 4 or 32 (these numbers
are from memory, not written down), but the one we ran into today was
large: 67108864.
I will head to the EXPLAIN, as well as to getting the memory dump
from the log.
Regards,
-Tom
---
On Tue, Oct 28, 2008 at 08:57:30AM -0400, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
> >> An easy trick I have found to set postgres password: $ sudo passwd
> >> postgres, and now you can type a new password. So now you can sw
Mohd Alkhaldi escribió:
> Dear All,
>
> I've postgres 7.4.21 , is there is any way to archive WAL ,
No. And even if you were to copy WAL logs by hand, it wouldn't work to
restore them. You need to upgrade at least past 8.0.
--
Alvaro Herrerahttp://www.Comm
Brent Austin wrote:
> Trying to install psqlodbc-08.03.0300 on Mac gets me this
> while I configure:
>
>
> client-6X-XXX-17-X14:~ brent1a$ cd /psqlodbc-08.03.0300
> client-6X-XXX-17-X14:psqlodbc-08.03.0300 brent1a$ sudo ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
On Mon, Oct 27, 2008 at 6:50 AM, Andreas Jochem <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a table containing x y z coordinates. But I have no geometry column?
> Is it possible to find the k nearest neighbors of any point. Is there
> something like a kd-tree Index in postgres???
>
cubes:
http:
Merlin Moncure wrote:
On Tue, Oct 28, 2008 at 10:42 AM, Vincas Dargis <[EMAIL PROTECTED]> wrote:
Hello everyone,
I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
crappy string replacement:
select regexp_replace('[EMAIL PROTECTED]&^&*()[]-=', '[^0-9]*' ,'')
..and I ge
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough to
use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated below
(see )when I run this command I get the following output (see
)
COPY abc FROM STDIN WIT
On Tue, Oct 28, 2008 at 10:42 AM, Vincas Dargis <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
> crappy string replacement:
>
> select regexp_replace('[EMAIL PROTECTED]&^&*()[]-=', '[^0-9]*' ,'')
>
> ..and I get:
> "[EMAIL PR
Hello everyone,
I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
crappy string replacement:
select regexp_replace('[EMAIL PROTECTED]&^&*()[]-=', '[^0-9]*' ,'')
..and I get:
"[EMAIL PROTECTED]&^&*()[]-="
So only thirst assurance where removed, while documentation states
Tom Darci <[EMAIL PROTECTED]> writes:
>Our PG server is serving up 50 databases or so (with identical
> schemas), and the largest one of those has started giving us "out of
> memory. failed on request of size n" errors in many places. This is a
> 9 GB database with 100+ tables, the larges
Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
EXPLAIN says that the correct index is being used -- it didn't used
to. However, pg_stat* says otherwise. In my test, I have exactly one
dh value. Running EXPLAIN with this value produces a plan using idx_dh
(the correct index), but pg_s
Reid Thompson wrote:
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough
to use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated
below (see )when I run this command I get the following output
(see )
C
Hi All,
Our PG server is serving up 50 databases or so (with identical
schemas), and the largest one of those has started giving us "out of
memory. failed on request of size n" errors in many places. This is a
9 GB database with 100+ tables, the largest of which have 4 million or
so row
On Tue, October 28, 2008 05:57, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
>> On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
>>> An easy trick I have found to set postgres password: $ sudo passwd
>>> postgres, and now you can type a new password. So now you can switch
>>> use
On Oct 28, 2008, at 8:22 AM, Brent Austin wrote:
configure: error: pg_config not found (set PG_CONFIG environment
variable)
How did you do your PostgreSQL install? In the normal install from
source, pg_config is in the bin folder with the rest of the usual
PostgreSQL executables.
Jo
On Tue, Oct 28, 2008 at 01:43:08PM +0100, Thomas wrote:
> Yes this allows to login remotely through ssh for instance. But it
> doesn't offer a bigger backdoor than having a weak password on a sudo
> account.
In my eyes, the you've just increased the attack surface available for
getting the data---
just type in 'pg_config' ,without quotes in terminal and see if it runs. if
not, you gotta find it. For instance by using:
find /usr -name pg_config
than if it does come up with whereabouts of it - stick it into PG_CONFIG env
variable:
export PG_CONFIG=/path/path/pg_config
and rerun configure in th
I've tried updating the path but it doesn't do anything. I'm not super savvy
with unix bashhow might I "run pg-config by hand"?
-thanks
From: Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
To: Brent Austin <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent:
Sam, I have been unable to understand your shell script well enough to
use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated below
(see )when I run this command I get the following output (see
)
COPY abc FROM STDIN WITH CSV HEADER;
\.
1
Sam Mason <[EMAIL PROTECTED]> writes:
> On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
>> An easy trick I have found to set postgres password: $ sudo passwd
>> postgres, and now you can type a new password. So now you can switch
>> user with: $ su postgres, and then connect to the DB with
On Tue, Oct 28, 2008 at 12:22 PM, Brent Austin <[EMAIL PROTECTED]> wrote:
> Trying to install psqlodbc-08.03.0300 on Mac gets me this while I
> configure:
>
> client-6X-XXX-17-X14:~ brent1a$ cd /psqlodbc-08.03.0300
> client-6X-XXX-17-X14:psqlodbc-08.03.0300 brent1a$ sudo ./configure
> checking for
Yes this allows to login remotely through ssh for instance. But it
doesn't offer a bigger backdoor than having a weak password on a sudo
account.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
On Tue, Oct 28, 2008 at 01:25:00PM +0200, Allan Kamau wrote:
> The alternative I am attempting is to use "COPY abc FROM STDIN WITH
> HEADER". I pipe the contents of the CSV file on my PC to the psql
> command (that connects to the remote PC) while issuing this copy command.
> This does seems not
On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote:
> An easy trick I have found to set postgres password: $ sudo passwd
> postgres, and now you can type a new password. So now you can switch
> user with: $ su postgres, and then connect to the DB with psql.
Won't that allow logins to the postg
On Tue, Oct 28, 2008 at 02:25:05PM +0400, Mohd Alkhaldi wrote:
> I've postgres 7.4.21 , is there is any way to archive WAL , I've tried
No.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-general mailing list (pgsql-general@po
On Mon, Oct 27, 2008 at 04:16:16PM -0400, Tom Lane wrote:
> Sam Mason <[EMAIL PROTECTED]> writes:
> > when something goes wrong (as code inevitably does) the database
> > will continue doing things automatically for you (like touching the
> > filesystem) when you're fighting against it trying to fi
Trying to install psqlodbc-08.03.0300 on Mac gets me this while I configure:
client-6X-XXX-17-X14:~ brent1a$ cd /psqlodbc-08.03.0300
client-6X-XXX-17-X14:psqlodbc-08.03.0300 brent1a$ sudo ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment i
Hi all,
I am trying to copy data (results of a SELECT * FROM abc WHERE ...) to a
remote PC (on my network).
If I execute the "COPY abc2 FROM abc.txt CSV WITH HEADER" on psql
connected to the remote PC, PostgreSQL will expect the file to be
resident on the (remote) server's file system (or atl
On 28/10/2008 07:52, Ivano Luberti wrote:
> Can you please publicly share a link to this document ?
Surely - the docs are here:
http://www.slony.info/documentation/
and the one you want ought to be listed in the table of contents.
Ray.
---
Dear All,
I've postgres 7.4.21 , is there is any way to archive WAL , I've tried
to run =# select pg_switch_xlog();
ERROR: function pg_switch_xlog() does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
* What I know 7.4 is no
An easy trick I have found to set postgres password: $ sudo passwd
postgres, and now you can type a new password. So now you can switch
user with: $ su postgres, and then connect to the DB with psql.
Beware of pg_hba.conf, it is a bit tricky to understand how the
mechanism of authentification work
This looks like another form of the cross-column dependency problem. Postgres
is assuming that the revisions for all files will be evenly spread throughout
the date range and apparently there's a larger variety of dates than files so
it expects to find the last revision for that file fairly quickl
Shashank Sahni wrote:
when i posted the question on dspace mailing list..one of the guy
replied me with this solution..
createuser -h localhost -U postgres -d -A -P dspace
but he said that to execute the above command i must know the password
for the user postgres..
Edit the pg_hba.conf f
Can you please publicly share a link to this document ?
Abdul Rahman ha scritto:
>
> Thanks a lot Ray!
>
> I have found the document and going to follow this. If I face any
> difficulty then will prompt to archive.
>
> Regards,
>
> Abdul.
>
> --- On *Mon, 10/27/08, Raymond O'Donnell /<[EMAIL PROT
65 matches
Mail list logo