I have a client that wants a disaster recovery plan put into place. What is
the easiest way to do a hands free install of postgresql on a window box?
Thank you for your time,
Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.supernovasoftware.com
ugh, I'm going down a rathole with this... the dynamic part of the
query is the table name, and therefore, if I want to select into a row
variable, that variable's declaration needs to be dynamic, too. That
seems kind of crazy, and I see no way to do that anyway. Maybe I'm
going about this all
Joshua wrote:
Ok here is another simple question from a novice
Here is what my table looks like
firstname lastname fullname
-- -- ---
smith, john
Tom Lane [EMAIL PROTECTED] writes:
jef peeraer [EMAIL PROTECTED] writes:
Tom Lane schreef:
That's a foreign-key check, which is supposed to be done as the owner of
the table. You did not show us who owns table clienten, but I think
that role must be missing the intended(?) membership in
Tom Lane wrote:
Gunther Mayer [EMAIL PROTECTED] writes:
SELECT minimum(5,6) = 5
You're looking for the least/greatest functions (in 8.1 and up IIRC).
regards, tom lane
Awesome, that's exactly what I was looking for. My pl/pgsql minimum()
hack is gonna go
We are testing an application received from a collaborator that uses the
latest version of postgresql. After a few minutes of use we often see a
dozen or more postgres.exe listed by the windows XP task manager. This
is at a time when we are not doing anything with the application so
these
In response to Wm.A.Stafford [EMAIL PROTECTED]:
We are testing an application received from a collaborator that uses the
latest version of postgresql. After a few minutes of use we often see a
dozen or more postgres.exe listed by the windows XP task manager. This
is at a time when we are
Ok,
You guys must be getting sick of these newbie questions, but I can't
resist since I am learning a lot from these email lists and getting
results quick! Thanks to everyone for their contributions.
Here is my questions
I have a column that looks like this
firstname
-
Nicholas Barr writes:
It is much much safer to use pg_dump/pg_restore and know that your data is
consistent.
http://www.postgresql.org/docs/8.2/static/backup-dump.html
In particular look at the section
23.1.2. Using pg_dumpall
That will copy your entire data set including users.
Jason Long wrote:
I have a client that wants a disaster recovery plan put into place.
What is the easiest way to do a hands free install of postgresql on a
window box?
http://pginstaller.projects.postgresql.org/silent.html
//Magnus
---(end of
It is my understanding that once a standby server has reached the
point where it is often waiting for wal files to replay, it is pretty
much caught up to the primary server, with the differences being in
whatever wal files are currently in queue to be archived by the
primary. If I'm
On Jun 25, 2007, at 12:44 PM, Joshua wrote:
Ok,
You guys must be getting sick of these newbie questions, but I
can't resist since I am learning a lot from these email lists and
getting results quick! Thanks to everyone for their contributions.
Here is my questions
I have a column
On Jun 25, 2007, at 10:44 , Nicholas Barr wrote:
Only copy the data directory if both servers are offline and not
running
and if both servers use the same version of postgres.
... and have the same architecture. As you note, copying the data
directory is *not* the recommended way to do
Sorry, I have no idea about what happen!!
Sorry!
El Lunes, 25 de Junio de 2007, Andrej Ricnik-Bay escribió:
On 6/26/07, Adrián Ribao Martínez [EMAIL PROTECTED] wrote:
Ya he publicado la informacióne en la página y he abierto un post en el
foro para organizarlo.
Creo que lo mejor
Please, I'm sorry, I have sent some emails to the list that shouldn't go
there.
I have realized right now that there is a bug with Kmail, and every time I
reply a message, the email address is [EMAIL PROTECTED]
I have no idea why.
Sorry again.
---(end of
On Mon, 2007-06-25 at 13:42 -0500, Erik Jones wrote:
It is my understanding that once a standby server has reached the
point where it is often waiting for wal files to replay, it is pretty
much caught up to the primary server, with the differences being in
whatever wal files are
to impact that update you'd have to have a rule on
account_login. No rule on a child table will matter.
Well i had the same perception In order to double check this i created
an On insert do nothing rule on the child table and did an insertion to the
master table i.e (account_login) but
On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote:
On Mon, 2007-06-25 at 13:42 -0500, Erik Jones wrote:
It is my understanding that once a standby server has reached the
point where it is often waiting for wal files to replay, it is pretty
much caught up to the primary server, with the
errr... workmem is 256Mb of course, and 5m for explain analyze costs.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
How can I do OLD.columnName != NEW.columnName if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
Are you trying to do this from a plpgsql function? If so then I think
you should try to do this from a C function.
With C functions you will get more
I m having a problem while calling the procedure in prostgresql 8.2
from adoconnection, It gets executed for some time and after 5-10 call
it gives error startTransaction failed or CommitTransaction Failed.
CREATE OR REPLACE FUNCTION sp_getnewfiles(IN strserverid character
varying, IN nmaxcount
Suppose I want to update a statistics table S after an insertion into an
activity table A. In order to update S automatically, I can either create a
rule on A or create an after trigger on A. What's the performance
implication on using rule vs trigger? Thanks in advance.
Alfred
Hi. Sorry for being a bit emotional, I was pretty constructive in my
earlier posts (the earlier, the more constructive if you care to
search) but I am progressively getting pissed off :(
Thanks for the initial tip, running ANALYZE w/o vacuum is faster. Are
frequent vacuums even necessary if there
Hi All,
I want to dump the database by using pg_dump command but the problem is the
version at the server is 7.4 which doesn't support the provision for
excluding tables as in version 8.2.
There are 500+ tables in the database,from which 15-20 are of huge sizes.I
want to exclude them.Is there
On 20/06/2007, at 6:48 AM, Simon Riggs wrote:
This problem is fixed in 8.1.9. Seems it was inadvertently
introduced in
8.1.7 (Jan 2007) and was not reported as a bug until after 8.1.8 was
out, in early April.
The 8.1.9 release notes make no mention of the bug fix, which isn't
very
On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote:
On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote:
If I'm correct, then for large databases wherein it can
take hours to take a base backup, is there anything to be gained by
using incrementally updated backups?
If you are certain there
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
My database has shutdown several times in the last couple days. I have
no
idea why. I am running centos and I have not rebooted the server or
made
any configuration changes.
So in particular, you didn't disable memory overcommit?
LOG:
I'm getting duplicate rows returned. I don't know know and can't find
out how to construct the SQL to return what I want. I have an old
version of postgres which I cannot upgrade. I'm not even sure how to
get the version. Does this help?
$ grep -i version /pi/bin/setup
wtversion='2.0'
Hi all.
Under PGSQL v8.2.4, in a PL/PgSQL function whenver I try to run this
statement:
INSERT INTO table1 SELECT var1.*;
I get his message:
ERROR: record type has not been registered
CONTEXT: SQL statement INSERT INTO table1 select $1 .*
Of course var1 has been declared as table1 type.
Dear All,
I like to know about postgresql varchar[ ] data type equivalent in
Oracle.
Regards
Murali Doss T.S.
Hi All,
Am able to resolve the problem by setting PGPASSWORD=password in my
environment variables and passing the -q(quiet) command in my ant script.
Cheers,
Cha
cha wrote:
Hi All,
Am using the following command to import tables in my database. I got list
of tables which i need to
Is there a way to use a variable as the name of a table or column in plpgsql?
This might be a simple question, but I can't find the answer in the
docs. http://www.postgresql.org/docs/8.2/interactive/plpgsql-declarations.html
hints that there are data types that correspond to table/column, but I
En un mensaje anterior, Michael Glaesemann escribió:
On Jun 22, 2007, at 10:16 , Fernando Schapachnik wrote:
EXPLAIN SELECT DISTINCT p.id
Can you provide EXPLAIN ANALYZE? I suspect that when you rewrote the
query it changed how the planner took into account the statistics. If
your
Hi All,
Am using the following command to import tables in my database. I got list
of tables which i need to import.
So have made ant script and batch file to accomplish the purpose.
Ant script contains all the configurations with following command :
arg line=/c psql -h ${db.host} -p
Background: I have a number of schemas all of which contain a ticket
table having the same columns. The goal of the function xticket1
below is to collect all ticket rows satisfying some condition from all
those schemas, and additionally label each one by adding a new column
containing the name of
PLATEFORM: VC++ 7 , ADO, WINDOWS 2003, POSTGRE 8.2
I m having a problem while calling the procedure in prostgresql 8.2
from adoconnection, It gets executed for some time and after 5-10 call
it gives error either startTransaction failed or commit failed.
CREATE OR REPLACE FUNCTION
Trying to understand how I can get Pg 8.2 to match 'martín' when I
search for 'martin', and going through the documentation, specially
http://www.postgresql.org/docs/8.2/static/locale.html
http://www.postgresql.org/docs/8.1/static/functions-matching.html
Here is a transcript of my
On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote:
On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote:
On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote:
If I'm correct, then for large databases wherein it can
take hours to take a base backup, is there anything to be gained by
using
I would want to know as I make to control that the length of the field
character insert is of one sure dimension
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Hi,
I need a way to throw a message in a function, when an exception occurs, but I
don't want to write again and again the same message in every place I need to
throw it. So, is there a way to handle this situation in a more general
manner?
Thanks in advance,
--
Germán Hüttemann Arza
CNC -
--- Alfred Zhao [EMAIL PROTECTED] wrote:
Suppose I want to update a statistics table S after an insertion into an
activity table A. In order to update S automatically, I can either create a
rule on A or create an after trigger on A. What's the performance
implication on using rule vs trigger?
--- scuffio [EMAIL PROTECTED] wrote:
I would want to know as I make to control that the length of the field
character insert is of one sure dimension
A check constraint can certainly do this. If you want to generalize it, you
can roll you check
constraint into a domain (user defined column
Vincenzo Romano [EMAIL PROTECTED] writes:
Under PGSQL v8.2.4, in a PL/PgSQL function whenver I try to run this
statement:
INSERT INTO table1 SELECT var1.*;
I get his message:
ERROR: record type has not been registered
Works for me:
$ psql ...
Welcome to psql 8.2.4, the PostgreSQL
On Jun 21, 2007, at 10:30 , Germán Hüttemann Arza wrote:
I need a way to throw a message in a function, when an exception
occurs, but I
don't want to write again and again the same message in every place
I need to
throw it. So, is there a way to handle this situation in a more
general
On Jun 19, 2007, at 0:40 , cha wrote:
I want to dump the database by using pg_dump command but the
problem is the
version at the server is 7.4 which doesn't support the provision for
excluding tables as in version 8.2.
The v8.2 pg_dump will be able to dump data from the v7.4 server, so
Re-did the machine that was running out of memory and installed FreeBSD 6.2
AMD64.
The rows that used to fail now load.
Therefore, the problem is only with the i386 version.
Should I report this as a bug or is this nornal and expected?
---(end of
Sergei Shelukhin escribió:
* What other non-default configuration settings do you have?
I played w/shared buffers, setting them between 16k and 32k,~ 24k
seems to be the best but the difference is minimal. The work_mem
setting is 256kb, and I increased effective cache size to ~700Mb (~35%
On Jun 25, 2007, at 9:33 PM, Francisco Reyes wrote:
Therefore, the problem is only with the i386 version.
Should I report this as a bug or is this nornal and expected?
i wouldn't call it a bug to need more resources than you've got
available :-) obviously the limits on the i386 version
Vivek Khera writes:
i wouldn't call it a bug to need more resources than you've got
available :-)
Hm... now I am really confused.
The same settings on AMD64 work. So how are more resources available when
I have the same amount of memory and the same settings?
I even tried a machine with
On Jun 25, 2007, at 10:32 PM, Francisco Reyes wrote:
Hm... now I am really confused.
The same settings on AMD64 work. So how are more resources
available when I have the same amount of memory and the same
settings?
you set your maxdsize to the same as on i386? on even my smallest
Vivek Khera writes:
you set your maxdsize to the same as on i386?
On the AMD64 I have /boot/loader.conf as
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
In i386 I believe I had set
kern.ipc.semmni=256
kern.ipc.semmns=512
kern.ipc.semmnu=256
kern.maxdsiz=1600MB
Are there any solutions based on PostgreSQL that can support
distributing partitions (horizontal fragmentations) across different
nodes. It doesn't need to support distributed transaction, since data
inconsistent is not a critical problem in my situation.
---(end of
On 6/26/07, 金星星 [EMAIL PROTECTED] wrote:
Are there any solutions based on PostgreSQL that can support
distributing partitions (horizontal fragmentations) across different
nodes. It doesn't need to support distributed transaction, since data
inconsistent is not a critical problem in my
Having read
http://www.postgresql.org/docs/8.2/interactive/datatype-character.html
I am puzzling over this issue:
1) Is there ever ANY reason to prefer varchar(n) to text as a column type?
2) For instance, if I know that a character-type column will never
contain more than 300 characters,
On Mon, 25 Jun 2007, Pierre Thibaudeau wrote:
From my reading of the dataype documentation, the ONLY reason I can
think of for using varchar(n) would be in order to add an extra
data-type constraint to the column.
That's my understanding as well. I can think of a few reasons to use
char(n)
Pierre Thibaudeau [EMAIL PROTECTED] writes:
I am puzzling over this issue:
1) Is there ever ANY reason to prefer varchar(n) to text as a column type?
In words of one syllable: no.
Not unless you have an application requirement for a specific maximum
length limit (eg, your client code will
On Mon, Jun 25, 2007 at 12:35:11AM -0400, Tom Lane wrote:
Michael Fuhr [EMAIL PROTECTED] writes:
On Mon, Jun 25, 2007 at 09:51:30AM +0900, [EMAIL PROTECTED] wrote:
It seems that real takes 8 byte storage sizes.
Real is 4 bytes but other columns' alignment requirements might
result in no
Harpreet Dhaliwal wrote:
Can anyone help me out with funciton(s) to write a debug
output in a perl function on postgres.
Check out DBI-Link and see how it is done there:
http://pgfoundry.org/projects/dbi-link/
Yours,
Laurenz Albe
---(end of
Actually, table size shrinked a little.
But I misinterpreted it as no shrinking.
I expected much more shrinking.
Thank you for your concerns.
Michael Fuhr [EMAIL PROTECTED] wrote:
I see table sizes shrink on 64-bit sparc and x86 architectures, as
in the following example that results in
On Mon, Jun 25, 2007 at 12:35:11AM -0400, Tom Lane wrote:
As for that pg_dump measurement, the text form isn't going to get
smaller ... 1.2 is the same length as 1.2.
Non-text formats like -Fc should (or might) shrink, right? They
appear to in the tests I've done.
--
Michael Fuhr
[EMAIL PROTECTED] writes:
Real type takes 4 byte storage sizes and double precision takes 8 bytes.
I altered a data type from double precision to real and vacuumed DB.
But PostgreSQL's data disk usage did not shrinked.
And pg_dump size remained same.
It seems that real takes 8 byte storage
Michael Fuhr [EMAIL PROTECTED] wrote:
Altering a column's type rewrites the table so vacuuming afterward
shouldn't be necessary.
I'm gonna alter another table type from double precision to real.
This table size is lager than disk free space.
Can it be possible?
Previsouly, I saw continuous
Gregory Stark [EMAIL PROTECTED] wrote:
This could also be due to alignment restrictions on the other columns or the
row as a whole. If you're curious exactly what's going on and how to optimize
your table layout send your table definition and we can tell you exactly how
it's being laid out and
[EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] wrote:
This could also be due to alignment restrictions on the other columns or the
row as a whole. If you're curious exactly what's going on and how to optimize
your table layout send your table definition and we can tell you exactly
On Monday 25 June 2007 03:35, [EMAIL PROTECTED] wrote:
Michael Fuhr [EMAIL PROTECTED] wrote:
Altering a column's type rewrites the table so vacuuming afterward
shouldn't be necessary.
I'm gonna alter another table type from double precision to real.
This table size is lager than disk free
On Thursday 21 June 2007 04:39, Christan Josefsson wrote:
Ok.
Big thanks for the information.
You mentioned Bizgres, do you have any more information in that direction,
or do you know who to contact regarding information on Bizgres bitmap
indexes. If there is a bitmap index patch in Bizgres
[EMAIL PROTECTED] (Christan Josefsson) writes:
So you indicate that the so called bitmap index scan, a.k.a
in-memory bitmap indexes (right?), already adds such an
improvement when it comes to optimized response time on large
query sets (having the characteristics as normally
Thanks Robert!
So you indicate that the so called bitmap index scan, a.k.a in-memory bitmap
indexes (right?), already adds such an improvement when it comes to
optimized response time on large query sets (having the characteristics as
normally used to identify cases where bitmap indexes improves
Michael Fuhr [EMAIL PROTECTED] writes:
On Mon, Jun 25, 2007 at 12:35:11AM -0400, Tom Lane wrote:
Even with no other columns involved, if you're on a machine with
MAXALIGN = 8 (which includes all 64-bit platforms as well as some
that aren't), the row width won't shrink.
I see table sizes
I have a column with the following values (example below)
5673
4731
4462
5422
756
3060
I want the column to display the numbers as follows:
56.73
47.31
44.62
54.22
7.56
30.60
I have been playing around with string functions but cannot seem to
figure out a quick solution. Does anyone have any
Le lundi 25 juin 2007, Joshua a écrit :
I have been playing around with string functions but cannot seem to
figure out a quick solution. Does anyone have any suggestions?
Please let me know.
What about:
pgloader=# select a::float / 100 from (values(5673), (4731), (4462), (5422),
(756),
Chris Browne [EMAIL PROTECTED] writes:
But to be sure, there used to be a lot of burning interest in
on-disk bitmap indexes, and in-memory bitmap index scans have quenched
many of the flames...
Well, we had in-memory bitmaps already in 8.1, and the bitmap index work
happened since that.
I
On Mon, 25 Jun 2007, Joshua wrote:
I have a column with the following values (example below)
5673
4731
4462
5422
756
3060
Are these numbers that will be used in calculations, or are they strings?
I want the column to display the numbers as follows:
56.73
47.31
44.62
54.22
7.56
30.60
Ok here is another simple question from a novice
Here is what my table looks like
firstname lastname fullname
-- -- ---
smith, john
green, susan
Hello, I have to move all the data in my actual server to the new one.
I have several databases in postgresql, and I'd like to know the best way to
move them.
I thoung that maybe copying all the data directory... but I'm not sure, and I
don't know where it's stored.
I'd apreciate your help.
Ok here is another simple question from a novice
Here is what my table looks like
firstname lastname fullname
-- -- ---
smith, john
green,
Hello, I have to move all the data in my actual server to the new one.
I have several databases in postgresql, and I'd like to know the best way
to
move them.
I thoung that maybe copying all the data directory... but I'm not sure,
and I
don't know where it's stored.
I'd apreciate your
Thanks Michael and Steve.
Related question: If I previously had a
IF EXISTS (select ...)
statement, and the 'select ...' part now needs to be run with EXECUTE,
how do I check for existence? It looks like I need to do an 'INTO'
with a row variable? I can't seem to find an example snippet of
Ya he publicado la informacióne en la página y he abierto un post en el foro
para organizarlo.
Creo que lo mejor sería que fueras respondiendo a las preguntas que se
formulan en el. Esta es la direccion:
http://foro.universoheroes.com/showthread.php?tid=1105pid=21813#pid21813
Un saludo!
El
79 matches
Mail list logo
