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
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
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
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
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
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.
---
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
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
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
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 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 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
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 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
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
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
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:
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
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---
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, 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
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
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
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
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
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
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
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
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
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:
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
>
> 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
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
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
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
>
> 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
>
>
> 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
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
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
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.
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
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
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_
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
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
65 matches
Mail list logo
