Sergei Dubov wrote:
Hi guys,
I just installed the latest release of Postgres (8.2 native version) on
Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
postgres terminal. I mean I type in the password, and the feeling is
that it just hangs.
If you are running 8.2
On Wed, 18 Apr 2007 23:25:07 -0400, Sergei Dubov [EMAIL PROTECTED] wrote:
I just installed the latest release of Postgres (8.2 native version) on
Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
postgres terminal. I mean I type in the password, and the feeling is
that
Hello All,
can anybody please tell me which file name should given in %f parameter of
archive_command.
As per documantation
When not using WAL archiving, the system normally creates just a few
segment files and then recycles them by renaming no-longer-needed segment
files to higher
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Ashish Karalkar wrote:
Hello All,
can anybody please tell me which file name should given in %f parameter of
archive_command.
As per documantation
When not using WAL archiving, the system normally creates just a few segment files and
then recycles them by renaming no-longer-needed
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
For the web? *nix console? GTK? Mac?
--
Richard Huxton
Archonet Ltd
---(end of
David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
For the web? *nix console? GTK? Mac?
--
Richard Huxton
David Potts wrote:
David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.
There are also lots of commercial admin/data tools that will work with
PG - check the
If you want end-users to be doing the data entry, Andromeda may be what
you want.
http://www.andromeda-project.org/
The project is aimed at more complicated cases and may carry too much
overhead for what you want, but perhaps not.
David Potts wrote:
Can any body recommend a generic
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a job partner, who are testing the
Germán Hüttemann Arza wrote:
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
Old - you already have the new version in the
Ask the question: can I make sure I always have a complete trail? If
you insert the old row, you will always have the old values and the
table itself holds the new values.
Germán Hüttemann Arza wrote:
Hi,
I am developing a web application for auditing tables from a postgresql
database.
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
makost00012007-04-19 15:09:19
makost00012007-04-19 15:09:19
In the other I have the user name his group and the expiry date of his
account.
Name Group
Germán Hüttemann Arza wrote:
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a
In response to Tom Lane [EMAIL PROTECTED]:
Bill Moran [EMAIL PROTECTED] writes:
Just an FYI ... I remembered what prompted the cron job.
We were seeing significant performance degradation. I never did actual
measurements, but it was on the order of Bill, why is restoring taking
such a
Bill and Tom
Best to find out what kind of index you want to create beforehand
If your data is evenly distributed and exhibits High Cardinality (2 entries
for A,B,C...Z) then I would recommend a BTREE Index
If not (low cardinality scenarios such as gender) then create Bitmap Index
I cant speak
Peter Neu wrote:
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
makost00012007-04-19 15:09:19
makost00012007-04-19 15:09:19
In the other I have the user name his group and the expiry date of his
account.
Name
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
TIP 6: explain analyze is your friend
For Desktop
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a job partner, who are testing the
On Apr 17, 10:27 am, [EMAIL PROTECTED] (Mageshwaran) wrote:
hi everyone,
please any one give any methods to do incremental backups. it is urgent
.. help me
Regards
J Mageshwaran
Sorry, I don't have anything implemented, but I've been wondering
about this too. One way (not necessarily the
I have a requirement of incorporating a database in a hard disk drive.
Can postgresql do the job? Any consultants out here that have done this?
If not, any suggestions?
Ray Hurst
Western Digital
20511 Lake Forest Drive
Lake Forest, CA 92630
949-672-9853
On Apr 19, 9:41 am, Kev [EMAIL PROTECTED] wrote:
On Apr 17, 10:27 am, [EMAIL PROTECTED] (Mageshwaran) wrote:
hi everyone,
please any one give any methods to do incremental backups. it is urgent
.. help me
Regards
J Mageshwaran
Sorry, I don't have anything implemented, but I've been
On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
In a hard disk drive? My god, why? If you're doing embedded
programming, don't carry over applications that were never intended
for it. Go port eForth or Pygmy Forth to your hard drive, or at least
set up a C cross compiler, and write whatever hash tables you need.
If you're trying to make a
Reid Thompson wrote:
On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
http://www.gnome-db.org/
Glom (www.glom.org) would seem to fit the bill.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
If you want embedded SQL, you'll probably have only 1 user at a time so
sqlite is a better choice.
But do you want embedded SQL ?
On Wed, 18 Apr 2007 22:48:52 +0200, Raymond Hurst [EMAIL PROTECTED]
wrote:
I have a requirement of incorporating a database in a hard disk drive.
tsearch2 versus mysql FULLTEXT in the context of a large forum.
I guess you know the answer already, but it never hurts to have nice
graphics to show your boss.
http://peufeu.free.fr/ftsbench/
I will upload new versions with more results, and maybe other engines, as
I
This is very interesting and I'm interested if you write a paper, so
we could reference on.
Two days ago I gave a talk on Russian Internet Technologies conference
about new FTS we developed for 8.3 version and there was real interest.
btw, there are several performance optimization tips for
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of SYSV
memory available.
I compiled using:
./configure --without-readline
2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta:
Andrew Toth wrote:
Dear List,
I would like to download the version of source code containing
catversion.h with the line #define CATALOG_VERSION_NO 200611051. This
is first met in Changeset 26624
Raymond Hurst wrote:
I have a requirement of incorporating a database in a hard disk drive.
Well, back in the day there was a man called Dick Pick. The US Goverment had the
same request. They wanted a database incorporated into a hard disk drive, and
that's what they got. An operating
I see tables and indexes can be moved to a different tablespace.
Is there any way to move an entire database to a different tablespace?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Andrew Toth wrote:
2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta:
Andrew Toth wrote:
Dear List,
I would like to download the version of source code containing
catversion.h with the line #define CATALOG_VERSION_NO 200611051. This
is first met in Changeset
Walter Vaughan wrote:
Raymond Hurst wrote:
I have a requirement of incorporating a database in a hard disk drive.
Well, back in the day there was a man called Dick Pick. The US Goverment
had the same request. They wanted a database incorporated into a hard
disk drive, and that's what they
On 19/04/07, Andrej Ricnik-Bay [EMAIL PROTECTED] wrote:
On 4/15/07, Anton Melser [EMAIL PROTECTED] wrote:
it might even make more sense), and with KDE/Gnome these days, I don't
think there is much difference with XP...
Of course you could use fluxbox, twm or something else less
bloated ... my
I'm about to begin playing with incrementally updated backups for a
warm standby scenario, but I need some help understanding this
paragraph in postgres terms. From 23.4.5 in the 8.2.3 docs:
If we take a backup of the standby server's files while it is
following logs shipped from the
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory available.
The call to
Kevin Murphy wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/19/07 15:11, Dave Page wrote:
Walter Vaughan wrote:
Raymond Hurst wrote:
I have a requirement of incorporating a database in a hard disk drive.
Well, back in the day there was a man called Dick Pick. The US Goverment
had the same request.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/19/07 14:51, Francisco Reyes wrote:
I see tables and indexes can be moved to a different tablespace.
Is there any way to move an entire database to a different tablespace?
Move one table at a time?
- --
Ron Johnson, Jr.
Jefferson LA USA
Hi all,
I can't spot the trouble with this function definition:
create function dem.trf_null_empty_title()
returns trigger
language plpgsql
as $null_empty_title$
begin
if (NEW.title is null) then
return NEW;
end if;
if
I have one table.
create table u (
id integer,
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
---(end of
[EMAIL PROTECTED] (Kenneth Downs) writes:
If you want end-users to be doing the data entry, Andromeda may be
what you want.
http://www.andromeda-project.org/
The project is aimed at more complicated cases and may carry too much
overhead for what you want, but perhaps not.
Their choice of
Karsten Hilbert wrote:
Hi all,
I can't spot the trouble with this function definition:
create function dem.trf_null_empty_title()
returns trigger
language plpgsql
as $null_empty_title$
begin
if (NEW.title is null) then
return NEW;
end if;
chrisj wrote:
I would like to do a selective export of a number of tables from a large
database to import into a smaller (test) DB.
I know about: psql dbname -tc select * from tableX where whatever
tableX.dat
You might try
psql dbname -Atc select * from tableX where whatever tableX.dat
Richard Huxton wrote:
David Potts wrote:
David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.
PGAccess provides a spreadsheet like view of tables which users
Hi all,
I'm using Solaris 10 with 64-bit libpq library.
I wanted to bind a 64-bit integer, but it failed:
ERROR: incorrect binary data format in bind
parameter 1.
The code would succeed if the type of val is
uint32_t.
Doe anyone know how to fix this? Thanks a lot!
Flying-
reading the source displays
http://doxygen.postgresql.org/postgres_8c-source.html
/* Trouble if it didn't eat the whole buffer */
if (!isNull pbuf.cursor != pbuf.len)
ereport(ERROR,
Works for me on both 8.1 and 8.2. What client are you using?
John
On Apr 19, 2007, at 5:45 PM, Karsten Hilbert wrote:
I can't spot the trouble with this function definition:
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of
A.M. wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of
SYSV memory available.
The
On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert [EMAIL PROTECTED] wrote:
I can't spot the trouble with this function definition:
create function dem.trf_null_empty_title()
returns trigger
language plpgsql
as $null_empty_title$
begin
if (NEW.title is null) then
Kevin Murphy [EMAIL PROTECTED] writes:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of SYSV
memory available.
creating template1
Thanks Alan,
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I noticed one other post on this same problem of the fieldsep '\t' not
working but the only advise offered was to use \pset. Can \pset be used on
the command line, I can only
chrisj [EMAIL PROTECTED] writes:
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I don't think there's any provision for backslash-notation in that
switch; you'd need to type an actual tab character there. Depending on
what shell you
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
I wanted to bind a 64-bit integer, but it failed:
ERROR: incorrect binary data format in bind
parameter 1.
It sorta looks like you are trying to send that value to a parameter
that the server doesn't think is int8.
regards,
Francisco Reyes [EMAIL PROTECTED] writes:
I see tables and indexes can be moved to a different tablespace.
Is there any way to move an entire database to a different tablespace?
No. Moving the system catalogs on-the-fly would be an interesting
problem (uh, where did you say pg_class was? ...
chrisj wrote:
Thanks Alan,
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I noticed one other post on this same problem of the fieldsep '\t' not
working but the only advise offered was to use \pset. Can \pset be used on
the command
I was attempting to get info to answer a question on this mailing list.
I found a document that sounded appropriate here:
http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I can't
figure a way to download the document Apache 2.0, Tomcat 5.5, WARs
PostgreSQL 8.1 JDBC DataSources
58 matches
Mail list logo