weixiang tam wrote:
Hi all,
I am trying to look for the postgresql version 8.2.5 for Redhat Linux
5; however after looking through the link
(*http://www.postgresql.org/ftp/binary/v8.2.5/linux/rpms/redhat/rhel-5/*),
i am not able to locate the postgresql rpm release (i browsed most of
the mir
Hi all,
I am trying to look for the postgresql version 8.2.5 for Redhat Linux 5;
however after looking through the link (*
http://www.postgresql.org/ftp/binary/v8.2.5/linux/rpms/redhat/rhel-5/*), i
am not able to locate the postgresql rpm release (i browsed most of the
mirror site), is anyone know
On Mon, Nov 09, 2009 at 11:23:52PM +, Raymond O'Donnell wrote:
> On 09/11/2009 22:43, Raymond O'Donnell wrote:
> > Finally, you can use OUT parameters to return multiple values from the
> > function - this is handy if you need to return just a few values.
>
> Just to clarify further - this las
On Mon, Nov 09, 2009 at 06:09:19PM -0800, Richard Broersma wrote:
> Out of curiosity, what are the favorite editor for authoring the
> PostgreSQL document sgml files? (I would be shocked if the whole
> thing was developed from scratch using a simple text editor.)
You might be, but that's approxi
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sam Mason
Sent: Thursday, November 05, 2009 10:50 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dump native format will not restore correctly
On Thu, Nov 0
I have users table such as
create table users(
user_id bigserial,
user_name varchar(50),
user_surname varchar(100)
);
how can I write a function to return multiple rows? ( in plpgsql )
what is the return value of the function? records?
and how can i run it without running as selec
On Mon, 9 Nov 2009, Richard Broersma wrote:
Out of curiosity, what are the favorite editor for authoring the
PostgreSQL document sgml files?
http://developer.postgresql.org/pgdocs/postgres/docguide-authoring.html
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
--
I wrote an article about PITR , incremental backups and multiple timelines.
check out. http://jinxter555.blogspot.com/
it should be an easy read.
akp geek ha escrito:
Dear all -
Is there way to create incremental backups in postgres. I
am currently using 8.4.1 on solaris. I
Tim Uckun writes:
> I am sad to report that this does not work with ubuntu 9.04 postgres
> 8.3 installed from the packages. I have removed everything from
> pg_hba.conf except for the one line what says
> localallall ident map=pg_map
That's an 8.4 synta
On Mon, Nov 9, 2009 at 6:48 PM, akp geek wrote:
> Is there way to create incremental backups in postgres. I
> am currently using 8.4.1 on solaris. I am new to postgres. Can you please
> share your thoughts
I've read more about continuous back-ups:
http://www.postgresql.org/docs
Saving off the transaction log WAL files is a good way to do this.
Read this part of the manual:
http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html
...and see if that answers your questions.
On Nov 9, 2009, at 6:48 PM, akp geek wrote:
Dear all -
Is t
Dear all -
Is there way to create incremental backups in postgres. I
am currently using 8.4.1 on solaris. I am new to postgres. Can you please
share your thoughts
Regards
Michael Harris writes:
> Postgres is 8.2.3.
8.2.something-recent might have coped with this better; I notice
a couple of WAL replay bug fixes in the later release notes.
You should encourage an update ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-g
Hi Tom,
Postgres is 8.2.3.
The owners of this database have now decided to rebuild it from scratch so
please don't spend much more time on answering this. Although, I'd like to know
how to proceed in cases like this in case it ever happens again.
Regards // Mike
-Original Message-
Fro
On Mon, Nov 9, 2009 at 3:12 PM, Richard Sickler
wrote:
> Hi List,
>
> I'm trying to create a tablespace using the following command copied
> from pg_dumpall,
>
> CREATE TABLESPACE test OWNER postgres LOCATION 'd:/prodb';
>
> I receive the following message
>
> ERROR: directory "d:/proddb" is not
Out of curiosity, what are the favorite editor for authoring the
PostgreSQL document sgml files? (I would be shocked if the whole
thing was developed from scratch using a simple text editor.)
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.post
> I just tried with 8.4.1. Started with the default configuration, created
> data/pg_ident.conf with:
> pg_map root postgres
> pg_map postgres postgres
>
> Replaced in pg_hba.conf:
> < local all all trust
> by
>> local all all
Michael Harris writes:
> I have been asked to help recover a database that seems to have been
> corrupted after a power failure.
What PG version is this exactly?
> Also what does it mean by "Success" in the FATAL message?
It's probably a read-past-EOF case.
regards, to
Hi,
I have been asked to help recover a database that seems to have been corrupted
after a power failure.
This is what we see when psql tries to start up:
[2009-11-10 10:39:17 EST] LOG: checkpoint record is at 41E/BF2D5DC0
[2009-11-10 10:39:17 EST] LOG: redo record is at 41E/BF008F28; undo re
Ah, I finally found it http://pgfoundry.org/projects/textsearch-ja/
- Original Message -
From: "Gordon Callan"
To: pgsql-general@postgresql.org
Sent: Monday, November 9, 2009 2:36:18 PM GMT -08:00 US/Canada Pacific
Subject: [GENERAL] Tsearch2 with Japanese
Does anyone know wh
- "Daniel Verite" wrote:
> Tim Uckun wrote:
>
>
> > I am very confused about something though. Not one person here has
> > said anything about how pg_ident works or what I did wrong. Is
> > pg_ident deprecated? Is there no way to accomplish this with
> pg_ident?
>
> I just tried with 8.4
Tim Uckun wrote:
> I am very confused about something though. Not one person here has
> said anything about how pg_ident works or what I did wrong. Is
> pg_ident deprecated? Is there no way to accomplish this with pg_ident?
I just tried with 8.4.1. Started with the default configuration
On 09/11/2009 22:43, Raymond O'Donnell wrote:
> On 19:59, wrote:
>> how can I write a function to return multiple rows? ( in plpgsql )
>
> Yep, it's all in the docs:
>
> http://www.postgresql.org/docs/8.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
[snip]
> Finally, you
hubert depesz lubaczewski wrote:
> => pacman -Ql docbook-sgml
> docbook-sgml /usr/
> docbook-sgml /usr/share/
> docbook-sgml /usr/share/sgml/
> docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
> docbook-sgml /usr/share/sgml/docbook-sgml-4.2/calstblx.dtd
> docbook-sgml /usr/share/sgml/docbook-sgml-4.
On 19:59, wrote:
> how can I write a function to return multiple rows? ( in plpgsql )
Yep, it's all in the docs:
http://www.postgresql.org/docs/8.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
> what is the return value of the function? records?
Depends on how you declar
Does anyone know where I can locate a Japanese parser and dictionary to use
with Tsearch2? There was a link (http://www.oss.ecl.ntt.co.jp/tsearch2j/
) to a Contrib at one time but this link is now dead :-( Any leads would be
appreciated.
Hi List,
I'm trying to create a tablespace using the following command copied
from pg_dumpall,
CREATE TABLESPACE test OWNER postgres LOCATION 'd:/prodb';
I receive the following message
ERROR: directory "d:/proddb" is not empty
a \db yields
List of tablespaces
Name| Owner |
--- Begin Message ---
I have users table such as
create table users(
user_id bigserial,
user_name varchar(50),
user_surname varchar(100)
);
how can I write a function to return multiple rows? ( in plpgsql )
what is the return value of the function? records?
and how can i run it w
On Mon, Nov 09, 2009 at 11:44:31PM +0200, Peter Eisentraut wrote:
> On mån, 2009-11-09 at 20:16 +0100, hubert depesz lubaczewski wrote:
> > my docbook related packages:
> > => pacman -Q | grep -i docbook
> > docbook-xml 4.5-3
> > docbook-xsl 1.74.0-1
> > docbook2x 0.8.8-7
> You need the SGML versio
On mån, 2009-11-09 at 10:57 +, David Edwards wrote:
> If we have users from all over the world storing data in our database
> with all sorts of languages, which locale should we use to ensure
> these string functions behave as they expect?
Try en_US.utf8. It is pretty language neutral.
--
On mån, 2009-11-09 at 20:16 +0100, hubert depesz lubaczewski wrote:
> my docbook related packages:
> => pacman -Q | grep -i docbook
> docbook-xml 4.5-3
> docbook-xsl 1.74.0-1
> docbook2x 0.8.8-7
You need the SGML version of DocBook.
--
Sent via pgsql-general mailing list (pgsql-general@postgres
2009/11/9 Tom Brown :
> Hey guys!
>
> I would like to know how to query for the existence of a primary key on
> a table. All of the tables have the column 'id' in them. That should be
> the primary key. However, the primary key constraint got "lost" somehow.
> Probably due to stupidity on my part.
>
> authenication type is controlled via the pg_hba.conf file.
>
> frankly, I've never used the pg_ident file, it just seems like it would add
> more confusion to things. But, it appears to use it you need a
> map=/mapname/ primitive in your pg_hba.conf
>
That's why I attempted to do. I read th
> But afterwards, inside the script, you could use su to temporarily switch to
> a less priviledged user:
>
> ... commands running as root
> su postgres -c 'psql ' # running as postgres
> ... running as root again
OK I will try this.
I am very confused about something though. Not one person
Hey guys!
I would like to know how to query for the existence of a primary key on
a table. All of the tables have the column 'id' in them. That should be
the primary key. However, the primary key constraint got "lost" somehow.
Probably due to stupidity on my part.
I just want to add back the prim
Hi,
I just recently migrated my workstation to Arch Linux, and now I have
problem with building docs for PostgreSQL on it.
I'm using cvs HEAD version, and when running ./configure I get:
./configure \
--prefix=/home/pgdba/work \
--with-pgport=5850 \
--with-tcl \
--
Uwe Schroeder wrote:
On Sunday 08 November 2009 11:38:28 pm Uwe Schroeder wrote:
(why it uses a transaction for a simple select is the other thing).
Every database interaction happens within a transaction.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Sunday 08 November 2009 11:38:28 pm Uwe Schroeder wrote:
> I've googled, but there's 0 hits.
>
> I have an issue with a ton of "idle in transaction" backends.
> What I noticed is when I look at pg_locks, pretty much all of the processes
> being idle in transaction have an exclusive lock of lock
On Mon, Nov 9, 2009 at 09:47, Anders Moe wrote:
>
> Hi all
> We're trying to get our 64 bt windows application to use postgresql, which
> means I have to #include stuff from psql and link to 64 bit versions of the
> libs. Which do not seem to exist.
> Spesifically I need to get Qt compiled with ps
Sam Mason wrote:
Why does Postgres need to be 64bit, couldn't you go through the windows
ODBC layer if you want 64 bit client support? Also, isn't PostGIS just
server side and hence you shouldn't have to worry about it client side?
ODBC would be a bad choice for a postgres specific program
Uwe Schroeder wrote:
I've googled, but there's 0 hits.
I have an issue with a ton of "idle in transaction" backends.
What I noticed is when I look at pg_locks, pretty much all of the processes being
idle in transaction have an exclusive lock of locktype "virtualidx
"Idle in Transaction" o
Tim Uckun wrote:
either create a postgres user named 'root' and give it superuser privileges,
In order to do that I need to connect to the database with my script
which is running under the root account.
if you are root, use
su -c "psql -f /path/to/script.sql" postgres
or
Laurenz,
I have juste finished to build PostgreSQL 8.3.8 with OBJECT_MODE set to
32 and I have exactly the same error as the beginning :
# export OBJECT_MODE=32
# cd /home/PostgreSQL_8.3.8/sources/postgresql-8.3.8
# ./configure => OK
# gmake 2>&1 | tee gmake_PGS_8.3.8_v4.log
In file included
Thanks, it works..
The problem is that ..
I create dynamically the query and verified a few things inside the function
before execute it.
Regards, Yadira
- Mensaje original -
De: "Thom Brown"
Para: "Yadira Lizama Mue"
CC: pgsql-general@postgresql.org
Enviados: Lunes, 9 de Noviembr
That gives me an idea what others are doing.
Thank you Mark, : )
> Date: Mon, 9 Nov 2009 09:24:28 -0500
> From: postg...@lambic.co.uk
> To: compuguruchrisbar...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Looking for a script that performs full online backup
> of
2009/11/9 Yadira Lizama Mue :
>
> Hi,
> I have a function which receive a parameters as text. This text is a query. I
> want to execute this query, but I don't know how. Can any one help me?
> Regards,
> Yadira
>
>
> CREATE OR REPLACE FUNCTION myfunction(text)
> RETURNS void AS
> $BODY$
> --I wan
Hi Laurenz, hi Daniel,
I have always run "gmake distclean" before relaunching a build.
Maybe the32-bit build failed because I have not set and exported the
"OBJECT_MODE" environment variable.
I will try to build PostgreSQL once again with "export OBJECT_MODE=32".
I continued to test a 64-bit
Hi,
I have a function which receive a parameters as text. This text is a query. I
want to execute this query, but I don't know how. Can any one help me?
Regards,
Yadira
CREATE OR REPLACE FUNCTION myfunction(text)
RETURNS void AS
$BODY$
--I want execute the text I pass by parameters as a
On Sunday 08 November 2009 10:48:49 pm Tim Uckun wrote:
> > then say you're postgres in the script with the -U (if you're using psql)
> >
> > AS ROOT:
> > psql -U postgres -h remote_db dbname
> >
> > Note that ident doesn't work so well between machines, so you might
> > want to look at .pgpass
>
>
Thanks Jan that was the issue. The SDK that my app was using for the
simulator build was was 10.5 while the my compile of libpq was using
10.6. Once I forced libpq to compile with 10.5 all my problems went
away. Thanks for your help I appreciate it.
On Mon, Nov 9, 2009 at 8:40 AM, Jan Otto wrote
Alexandra Roy wrote:
> It was a 32-bit build as I didn't have set the "OBJECT_MODE" to 64.
> I call configure and make using as root user:
>
> # ./configure
> # gmake
>
> The releases of "make" and "gcc" are :
> make-3.80-1
> gcc-4.2.0-3
Hmmm, I dont get the error if I set OBJECT_MODE to
> have a shell script that
performs a full online backup of postgres?
Full backup ex. pg_dumpall
Daily backup (dump) / database:
- - - - - - - - - - - - - - -
#!/someshellpath like /bin/sh or /bin/bash or /bin/ksh ...
#daily.sh
#default plaintext
#usage: daily.sh [c|t|p]
#
PORT=5432
HOST="loca
hi bob,
Undefined symbols:
"_fopen$UNIX2003", referenced from:
_parseServiceInfo in libpq.i386(fe-connect.o)
_PasswordFromFile in libpq.i386(fe-connect.o)
ld: symbol(s) not found
collect2: ld returned 1 exit status
Any help would be greatly appreciated.
hm, fopen is a standard c (libS
On Mon, Nov 09, 2009 at 09:15:03AM -0500, Chris Barnes wrote:
> Would anyone in the postgres community have a shell script that
> performs a full online backup of postgres?
Here's roughly what we do:
REMOTE="foo"
DATA="/srv/pgdata"
WAL="/var/lib/pgsql/wal-archive"
PSQL="/usr/bin/psql"
RSYNC="/us
There are renamed tables with one leading underscore sitting on the system
right now. I don't know how many mechanisms there are for renaming, as this
renaming (until now) was done from a "rename" function within pgAdmin or EMS
PG-SQL Manager - this is the first time I can think of having explic
On Mon, Nov 09, 2009 at 09:15:03AM -0500, Chris Barnes wrote:
> Would anyone in the postgres community have a shell script that
> performs a full online backup of postgres?
Have you tried pg_dumpall?
--
Sam http://samason.me.uk/
--
Sent via pgsql-general mailing list (pgsql-general@postgres
Would anyone in the postgres community have a shell script that performs a full
online backup of postgres?
Any help would be appreciated.
_
Windows Live: Keep
On Mon, Nov 09, 2009 at 01:47:55PM +0100, Anders Moe wrote:
> As far
> as ODBC is concerned I'm just working from the assumption that a native link
> is generally preferable.
You'll get a bit more control, but most of the time that's not needed.
> If anyone tells me that the psql ODBC link has th
Hi Laurenz,
It was a 32-bit build as I didn't have set the "OBJECT_MODE" to 64.
I call configure and make using as root user:
# ./configure
# gmake
The releases of "make" and "gcc" are :
make-3.80-1
gcc-4.2.0-3
Please find below the result of that you ask me:
1. # grep -i large confi
Hi Sam,
Typo in my haste on initial mail. attlen should actually be
atttypmod.
> > update pg_attribute set attlen = 4 +
> > where attname = 'yourcolumnname'
update pg_attribute set ATTTYPMOD = 4 +
where attname = 'yourcolumnname' and
> It will also update *every* column with that name. Some
> I am trying to compile PostgreSQL 8.3.8 on AIX 5.3 TL9 (64 bits).
> The ".configure" has been executed with success without any
> error but the compilation of PostgreSQL with "gmake" fails.
>
> Please find below the errors I get :
>
>
> In file included from psqlscan.c:2385:
> /
It's true that PostGIS is server side, so that's not really an issue. As far
as ODBC is concerned I'm just working from the assumption that a native link
is generally preferable. If anyone tells me that the psql ODBC link has the
same features/performance that's fine with me.? :)
Anders
On Mo
On Mon, Nov 09, 2009 at 09:47:48AM +0100, Anders Moe wrote:
> We're trying to get our 64 bt windows application to use postgresql, which
> means I have to #include stuff from psql and link to 64 bit versions of the
> libs. Which do not seem to exist.
>
> Spesifically I need to get Qt compiled with
On Mon, Nov 09, 2009 at 05:43:30PM +0530, Anand wrote:
> As i need to update the PostgreSQL version 8.2.6 with higher versions.
> But in release notes its mentioned that upgrading the PostgreSQL version
> 8.2.6 is as follows:
> PostgreSQL version 8.2.6-->8.2.7-->8.2.11-->8.2.14
AFAIK that's just a
Hi,
As i need to update the PostgreSQL version 8.2.6 with higher versions.
But in release notes its mentioned that upgrading the PostgreSQL version
8.2.6 is as follows:
PostgreSQL version 8.2.6-->8.2.7-->8.2.11-->8.2.14
or
can i directly upgrade the PostgreSQL version 8.2.6 with PostgreSQL versi
Try the following link. May be help u.
ftp://ftp-archives.postgresql.org/pub/source/v8.2.7/
--
Thanks
Sam Jas
--- On Mon, 9/11/09, Anand <1008an...@gmail.com> wrote:
From: Anand <1008an...@gmail.com>
Subject: [GENERAL] Donwload location for PostgreSQL version 8.2.7
To: pgsql-general@postg
On Mon, Nov 9, 2009 at 7:38 AM, Uwe Schroeder wrote:
> What I noticed is when I look at pg_locks, pretty much all of the processes
> being idle in transaction have an exclusive lock of locktype "virtualidx".
It's "virtualxid" as in "virtual transaction id" and hopefully more
than pretty much all
On Mon, Nov 9, 2009 at 12:22 PM, Anand <1008an...@gmail.com> wrote:
>
> Hi,
>
> I tried to download the PostgreSQL version 8.2.7 from the following
> location.
> http://www.postgresql.org/ftp/binary/v8.2.7/linux/rpms/redhat/rhel-5-i386/
>
> But i am not able to download any files. Every link is sho
Hi,
Some of postgresql's string functions behave differently depending on the
locale the cluster was created with. With the locales 'C' or 'en_US.utf8',
lower() does not lowercase non-ascii characters such as Ü (umlaut-u).
If we have users from all over the world storing data in our database with
Hi,
I tried to download the PostgreSQL version 8.2.7 from the following
location.
http://www.postgresql.org/ftp/binary/v8.2.7/linux/rpms/redhat/rhel-5-i386/
But i am not able to download any files. Every link is showing the "File Not
Found".
Please provide a link to download PostgreSQL version 8.
Hi,
Some of postgresql's string functions behave differently depending on the
locale the cluster was created with. With the locales 'C' or 'en_US.utf8',
lower() does not lowercase non-ascii characters such as Ü (umlaut-u).
If we have users from all over the world storing data in our database with
On 9 Nov 2009, at 8:38, Uwe Schroeder wrote:
I've googled, but there's 0 hits.
That's because you were looking for the wrong keyword, it doesn't read
"virtualidx" ;)
There is no info about table or anything, all the records look like:
locktype| database | relation | page | tuple |
Tim Uckun wrote:
> This script is a part of the initial setup script for the server. It
> has to run as root because when it starts running postgres is not
> installed and there is no postgres user.
But afterwards, inside the script, you could use su to temporarily switch to
a less privil
Hi all,
I am trying to compile PostgreSQL 8.3.8 on AIX 5.3 TL9 (64 bits).
The ".configure" has been
executed with success without any error but the compilation of
PostgreSQL with "gmake"
fails.
Please find below the errors I get :
In file included from
psqlscan.c:2385:
/usr/include/unistd
Hi all
We're trying to get our 64 bt windows application to use postgresql, which
means I have to #include stuff from psql and link to 64 bit versions of the
libs. Which do not seem to exist.
Spesifically I need to get Qt compiled with psql (and eventually postGIS).
Can anyone give me an update
On 11/7/09, Christian Petzold wrote:
> I'm trying to use the pgp_pub_encrypt and pgp_pub_decrypt_bytea functions
> to store some data in my db.
>
> This is how I encrypt:
>
> INSERT INTO "Test"(
>"test")
>VALUES (pgp_pub_encrypt('test', dearmor('-BEGIN PGP PUBLIC KEY
> BLOCK
>
>
> either create a postgres user named 'root' and give it superuser privileges,
In order to do that I need to connect to the database with my script
which is running under the root account.
> or switch to a different method of authentication for LOCAL users
I am confused. I presumed the prop
77 matches
Mail list logo
