On 5/8/07, Tom Lane [EMAIL PROTECTED] wrote:
I forgot to mention that any other operation that examines every table
row will fix all the hint bits as well. In particular a CREATE INDEX
would do that ---
I might be missing something, but I think CREATE INDEX work on
SnapshotAny and hence
Pavan Deolasee [EMAIL PROTECTED] writes:
On 5/8/07, Tom Lane [EMAIL PROTECTED] wrote:
I forgot to mention that any other operation that examines every table
row will fix all the hint bits as well. In particular a CREATE INDEX
would do that ---
I might be missing something, but I think
On 5/8/07, Tom Lane [EMAIL PROTECTED] wrote:
SnapshotAny is a no-op, but HeapTupleSatisfiesVacuum isn't.
Oh yes. My apologies for forgetting IndexBuildHeapScan()
Thanks,
Pavan
--
EnterpriseDB http://www.enterprisedb.com
The docs recommend using tar to perform a base backup for PITR.
Usually, tar reports notices like:
tar: Truncated write; file may have grown while being archived.
Did you call pg_start_backup(text) before you started to archive?
Yours,
Laurenz Albe
---(end of
Kirk Wythers wrote:
I am struggling to get a CASE WHEN statement to work within another
CASE WHEN. Here is my original code:
SELECT CASE WHEN w.station_id = site_near.station_id THEN w.obs_id
ELSE
s.obs_id END AS obs_id, site_near.station_id, site_near.longname,
w.year, w.doy,
On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
Hi, I'm trying to use tsearch2 for the first time and I'm having a
problem setting up a query
If I execute
SELECT * from test_table where ts_desc @@ to_tsquery ('helloworld');
it works, but I'm having the problem that the
Thanks for a good answer, I'll try to find a workaround. The number of
data_loggers will change, but not to frequently. I was actually hoping
to make a view showing the latest data for each logger, maybe I can
manage that with a stored procedure thingy...
- Create a table which contains your
Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
Since I'm very Linux unexperienced I used yum for this purpose.
I have all the commands installed, liek createdb (under /usr/bin/createdb
witch is not the location specified in the online manual), i also have the
psql
Just a final note:
Changing shmall did fix the problem. Thanks to everyone for the help.
the final working settings i used are:
kern.sysv.shmmax=4194304
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=4194304
I'm wondering how I managed to get it to work before,
Hi,
Manuel Preliteiro írta:
Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
I have the same system.
Since I'm very Linux unexperienced I used yum for this purpose.
I have all the commands installed, liek createdb (under
/usr/bin/createdb witch is not the location
Your a life saver :D
Thank you for the super fast anser
Manuel
On 5/8/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote:
Hi,
Manuel Preliteiro írta:
Hello, i have installed postgresql version 8.1.4-1.1 in Fedora 6
I have the same system.
Since I'm very Linux unexperienced I used yum for
Hi,
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow? (This is at least possible for primary key
columns which can be replaced by suitable indexes.)
Thank You
Felix
---(end of broadcast)---
TIP 1: if
On 08/05/2007 12:32, Felix Kater wrote:
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow? (This is at least possible for primary key
columns which can be replaced by suitable indexes.)
You can do that, but you'll lose the enforcement of referential
On Tue, 08 May 2007 12:48:30 +0100
Raymond O'Donnell [EMAIL PROTECTED] wrote:
You can do that, but you'll lose the enforcement of referential
integrity, which is what foreign keys give you.
If I get you right:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd
Am Dienstag, 8. Mai 2007 13:32 schrieb Felix Kater:
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow?
Not while preserving the semantics.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Hi,
How to get the time at which the previous REINDEX command was run?
With Thanks in advance,
AnooS
On 08/05/2007 13:14, Felix Kater wrote:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?
Here's my understandingan index is just that (an index) and
On Tue, 8 May 2007 14:19:12 +0200
Peter Eisentraut [EMAIL PROTECTED] wrote:
I like to keep my pg interface small: Can I replace foreign keys by
using indexes somehow?
Not while preserving the semantics.
I am not bound to indexes, however, wonder if foreign keys itself are
non-atomic
Hi,
where are the 'action code' (type char) of foreign keys defined for ON
DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
NULL, SET DEFAULT in pg_contraint?
In the manual (8.2) it is mentioned but not explained.
Thank You
Felix
---(end of
On Tue, May 08, 2007 at 02:14:54PM +0200, Felix Kater wrote:
If I get you right:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using indexes)?
A unique index is not
Felix Kater [EMAIL PROTECTED] writes:
where are the 'action code' (type char) of foreign keys defined for ON
DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
NULL, SET DEFAULT in pg_contraint?
Per the comment in pg_constraint.h:
/*
* Valid values for confupdtype and
Martijn van Oosterhout [EMAIL PROTECTED] writes:
On Tue, May 08, 2007 at 02:14:54PM +0200, Felix Kater wrote:
There is *no complete* substitute for foreign keys by using *indexes*
since I'd loose the referencial integrity (whereas for unique contraints
there *is* a full replacement using
On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote:
My next question is this: what are the dangers of turning fsync off in the
context of a high-availablilty cluster using asynchronous replication?
My real question is why you want to turn it off. If you're using a
battery-backed
On May 7, 2007, at 1:58 PM, Jeff Davis wrote:
Second, it seems that it can cause a bad backup to occur if you
pass the
z option to tar. Instead, piping the output of tar through the
compression program seems to avoid that problem (i.e. tar cf - ... |
gzip ...). I am using FreeBSD's tar, other
On May 7, 2007, at 3:10 PM, Thomas F. O'Connell wrote:
I'm attempting to design a postgres system whereby an authoritative
primary server simultaneously feeds continuous archives to a number
of warm standby servers that live both on the local network and on
remote networks.
The sticking
On May 8, 2007, at 2:02 AM, Albe Laurenz wrote:
Kirk Wythers wrote:
I am struggling to get a CASE WHEN statement to work within another
CASE WHEN. Here is my original code:
SELECT CASE WHEN w.station_id = site_near.station_id THEN w.obs_id
ELSE
s.obs_id END AS obs_id,
Hi,
From the documentation:
# SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE 'MST';
timezone
-
2001-02-16 18:38:40
MST is UTC-07, so i would expect that i can replace MST with UTC-07, but:
# SELECT TIMESTAMP WITH TIME ZONE '2001-02-16
On May 8, 2007, at 3:29 AM, PFC wrote:
Create a table which contains your list of loggers (since it's good
normalization anyway, you probably have it already) and have your
data table's logger_id REFERENCE it
BTW, you could do that dynamically with a subselect: (SELECT DISTINCT
logger_id
There are other ways to influence the selection of a seqscan, notably
effective_cache_size and random_page_cost.
First, you need to find out at what point a seqscan is actually
faster than an index scan. That's going to be a trial and error
search, but eventually if you're going back far
On May 7, 2007, at 11:01 AM, Karsten Hilbert wrote:
On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote:
GiST can also be useful if you have to query in multiple dimensions,
which can occur outside the normal case of geometry. Best example I
know of is a table containing duration
On Mon, 2007-05-07 at 15:10 -0500, Thomas F. O'Connell wrote:
I'm attempting to design a postgres system whereby an authoritative
primary server simultaneously feeds continuous archives to a number of
warm standby servers that live both on the local network and on remote
networks.
The
Andreas Schultz [EMAIL PROTECTED] writes:
MST is UTC-07, so i would expect that i can replace MST with UTC-07, but:
# SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME
ZONE 'UTC-07';
timezone
-
2001-02-17 08:38:40
The time returned is at
Hi,
I compiled the latest and greatest PG server on SUSE systems until now.
Now I want to stay with the official binaries of the Debian project
because I plan to evaluate if it is really that good for a server as
everybody is telling me.
It should get a server with only the minimum of
Simon Riggs wrote:
then I updated the master with a batch of inserts, but after a while the
slave stopped with
these messages:
LOG: restored log file 00010021 from archive
LOG: record with zero length at 0/2148
LOG: invalid primary checkpoint record
LOG: restored log
I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I need
a shared lib version of the client libs for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the static
libraries are built. This seems true with either xlc (8.x) or gcc (3.3.2).
I use npgsql 1.0 to access a PostgreSql 8.2.3 database. Recently, I
decided to test with standard_conforming_strings = on and I noticed that
npgsql still sends double-backslashes, which corrupts the data.
This is especially bad with byte arrays: if I insert N bytes I get back
4*N bytes
Sic Transit Gloria Mundi [EMAIL PROTECTED] writes:
I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I
need a shared lib version of the client libs for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the
static libraries are built. This
Hi,
I'm writing a function in plpgsql and i need to do the following:
I have a string in the following format.
mail.yahoo.com
In this string, i need to figure out the number of dots in it and split the
string into two
on last but one dot.
Is there any way to accomplish this.
Please let me
I've got a bunch of users on VB applications connecting to PG 8.2.3 via
psqlodbc with SSL. For a variety of reasons, some good, some probably
bad, I have the app open a connection and leave it open, using it as
needed to run queries back and forth.
If I look in my logs, I see loans of little
Jasbinder Singh Bali [EMAIL PROTECTED] schrieb:
Hi,
I'm writing a function in plpgsql and i need to do the following:
I have a string in the following format.
_m_a_i_l_._y_a_h_o_o_._c_o_m
In this string, i need to figure out the number of dots in it and split the
Number
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle session timeout
kicking in (most likely on the client side) and dropping the connection.
There's no such timeout in the Postgres server, for
On Tue, 2007-05-08 at 10:25 -0500, Jim Nasby wrote:
On May 7, 2007, at 1:58 PM, Jeff Davis wrote:
Second, it seems that it can cause a bad backup to occur if you
pass the
z option to tar. Instead, piping the output of tar through the
compression program seems to avoid that problem (i.e.
On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
The docs recommend using tar to perform a base backup for PITR.
Usually, tar reports notices like:
tar: Truncated write; file may have grown while being archived.
Did you call pg_start_backup(text) before you started to archive?
On 5/8/07, Jeff Davis [EMAIL PROTECTED] wrote:
On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
The docs recommend using tar to perform a base backup for PITR.
Usually, tar reports notices like:
tar: Truncated write; file may have grown while being archived.
Did you call
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle session timeout
kicking in (most likely on the client side) and dropping the connection.
There's no such timeout in the
On Tue, 2007-05-08 at 13:24 -0400, Merlin Moncure wrote:
On 5/8/07, Jeff Davis [EMAIL PROTECTED] wrote:
On Tue, 2007-05-08 at 08:47 +0200, Albe Laurenz wrote:
The docs recommend using tar to perform a base backup for PITR.
Usually, tar reports notices like:
tar: Truncated write;
On Tue, 2007-05-08 at 18:09 +0200, Andreas wrote:
Hi,
I compiled the latest and greatest PG server on SUSE systems until now.
Now I want to stay with the official binaries of the Debian project
because I plan to evaluate if it is really that good for a server as
everybody is telling me.
On Tue, 2007-05-08 at 13:21 +0100, Anoo Pillai wrote:
Hi,
How to get the time at which the previous REINDEX command was run?
I don't think that information is explicitly stored. You can log
statements like that and that might help in the future.
If you really need to know, a REINDEX
Is there a version of PostgreSql that can be embedded with an application?
I have a Mono application and when I deploy it, I would like to deploy a
postgresql database with it, but embedded, so the end user doesn't have to
install postgresql seperately. Is this possible?
--
Thanks,
Austin
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle session timeout
kicking in (most likely on the client side) and dropping
Austin Winstanley schrieb:
Is there a version of PostgreSql that can be embedded with an application?
I have a Mono application and when I deploy it, I would like to deploy a
postgresql database with it, but embedded, so the end user doesn't have
to install postgresql seperately. Is this
On Tue, 2007-05-08 at 13:26, Austin Winstanley wrote:
Is there a version of PostgreSql that can be embedded with an
application?
I have a Mono application and when I deploy it, I would like to deploy
a postgresql database with it, but embedded, so the end user doesn't
have to install
On Tue, 8 May 2007, Scott Marlowe wrote:
Is there a version of PostgreSql that can be embedded with an
application?
Nope, and it's not real likely to happen. Take a look at sqllite.
Yes, SQLite (http://www.sqlite.org/) is the way to go for embedded RDBMS.
Syntax is close to that of
Hi there,
Actually my PostgreSQL server is running on a Athlon
XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
I would like to buy a new server, could you please
give me some information about the specs??
Is it important to have a Dual (or even Quad)
processor??? Will PostgreSQL use them??
On Tue, 2007-05-08 at 14:04, MaRCeLO PeReiRA wrote:
Hi there,
Actually my PostgreSQL server is running on a Athlon
XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
I would like to buy a new server, could you please
give me some information about the specs??
Is it important to have a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/08/07 14:04, MaRCeLO PeReiRA wrote:
Hi there,
Actually my PostgreSQL server is running on a Athlon
XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
I would like to buy a new server, could you please
give me some information about the
8 maj 2007 kl. 21.07 skrev Rich Shepard:
On Tue, 8 May 2007, Scott Marlowe wrote:
Is there a version of PostgreSql that can be embedded with an
application?
Nope, and it's not real likely to happen. Take a look at sqllite.
Yes, SQLite (http://www.sqlite.org/) is the way to go for
On Tue, 2007-05-08 at 14:25, Scott Marlowe wrote:
On Tue, 2007-05-08 at 14:04, MaRCeLO PeReiRA wrote:
Hi there,
Actually my PostgreSQL server is running on a Athlon
XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
I would like to buy a new server, could you please
give me some
I am trying to bring up a disaster recovery database using a cold-copy of
the datafiles on a different machine. I've got all WAL files since this
copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB
when I bring it up?
Thanks!
Chris
-
Porell, Chris wrote:
I am trying to bring up a disaster recovery database using a cold-copy of
the datafiles on a different machine. I've got all WAL files since this
copy was made. Is it possible to make a 7.4 DB apply the WALs to the DB
when I bring it up?
No, you need to be running 8.x.
So, I have a customer who just had their pg_dump?
what's that? moment after some broken software
managed to delete everything in a table.
But they do have filesystem level backups. It's running
on 7.4.something, and the tables contain just varchar,
text, integer and timestamp data. I'm going to
Scott Marlowe wrote:
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle session timeout
kicking in (most likely on the client
Thanks for the info.
What, then, is the best way to achieve my goal of having a standby DB that
can be kept within 15 minutes or so in sync with the primary? periodic
pg_dump/restore? Unfortunately, I can't upgrade right now.
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL
Porell, Chris wrote:
Thanks for the info.
What, then, is the best way to achieve my goal of having a standby DB that
can be kept within 15 minutes or so in sync with the primary? periodic
pg_dump/restore? Unfortunately, I can't upgrade right now.
www.slony.info
-Original
Andreas wrote:
Hi,
I compiled the latest and greatest PG server on SUSE systems until now.
Now I want to stay with the official binaries of the Debian project
because I plan to evaluate if it is really that good for a server as
everybody is telling me.
It should get a server with only the
On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some sort of an idle
Scott Marlowe wrote:
On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is that there is some
Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
Scott Marlowe wrote:
On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
Tom Lane wrote:
Sean Murphy [EMAIL PROTECTED] writes:
I'm WAY out of my depth here, but my impression, based on the
circumstances, is
On Tue, 2007-05-08 at 17:35, Sean Murphy wrote:
Scott Marlowe wrote:
Well, you could set it on individual workstations instead of on the
server. I.e. if you set tcp_keepalive on your workstation to 500, but
leave Wally and Dilbert set at the default 7200 then they'd still
timeout and
Hi,
I have a pl/pgsql in which i have to print various variable values during
the execution of the function to see
what values are getting populated inside those variables with due course of
time.
PRINT variable name
doesn't work.
Can anyone tell me how to print these values??
Thanks,
Hi,
I have a pl/pgsql in which i have to print various variable values during
the execution of the function to see
what values are getting populated inside those variables with due course of
time.
PRINT variable name
doesn't work.
Can anyone tell me how to print these values??
Thanks,
you can use
RAISE NOTICE 'i want to print % and %', var1,var2;
then run your function and click the MESSAGE tab at the bottom of your query
analyzer screen and you'll see sometime like
NOTICE: i want to print value of var 1 and value of var2
you can use any number of RAISE NOTICE statements as
\echo will print contents of whatever follows
http://www.postgresql.org/docs/8.1/static/app-psql.html
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email
Hello All,
Can anybody please point me to Advantages and Disadvantages of using view
With Regards
Ashish...
74 matches
Mail list logo