On Mon, Oct 27, 2008 at 11:34 PM, Shashank Sahni [EMAIL PROTECTED] wrote:
On Tue, Oct 28, 2008 at 10:52 AM, Tony Caduto
[EMAIL PROTECTED] wrote:
Edit the pg_hba.conf file and add a entry for the PC you are doing your
admin from and set it to Trust.
When set to trust you won't need a
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 PROTECTED]/*
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
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
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
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
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
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
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 fix
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
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
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 to
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:
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 a
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 psql.
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 code/)when I run this command I get the following output (see
output/)
output
COPY abc FROM STDIN WITH
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
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
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.
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
user with: $ su
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
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 code/)when I run this command I get the following output
(see
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
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 largest of
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 that
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
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 code/)when I run this command I get the following output (see
output/)
output
COPY
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 get:
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:
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 Herrera
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 switch
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 end
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
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 code/)when I run this command I get the
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
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
--
Sent via
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 else
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 mailing
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 configuration
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
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
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
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
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
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 always
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 pgsql-general@postgresql.org
Sent: Wednesday, October 29, 2008 8:01 AM
Subject: [GENERAL]
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 OSSP-UUID
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:
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 place
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
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
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
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 installation I'd be
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
64 matches
Mail list logo