Hello,
My DB crashed without any recent backup.
I only have old DB files.
How can i use WAL files and restore_command to restore ?
Thanks
Franck R.
Hello,
My DB crashed without any recent backup.
I have old DB files.
Can i use "base" folder files to restore ?
Thanks
Franck R.
am Tue, dem 28.08.2007, um 10:56:38 +0530 mailte Ashish Karalkar folgendes:
> Hello all,
>
> I have a database abc with owner c .
> I want to grant only read access on this DB abc to user d.
> More specificaly to a schema abcs in the databse abc.
> Is ther any way to do so?
>
> I have more
Hello all,
I have a database abc with owner c .
I want to grant only read access on this DB abc to user d.
More specificaly to a schema abcs in the databse abc.
Is ther any way to do so?
I have more than 1000 table so dont want to list all the table name in the
grant command.
Thanks in advan
Continuining with my efforts to get similar functionality as mysql's
mysqlimport --replace I want to ask for the list's opinion on which is
better
What currently is happening
1. select from mssql (into CSV via PerlDBI)
2. psql\copy into PG
3. pg chokes on duplicate pkeys as there's no --replace o
On Tue, Aug 28, 2007 at 02:03:29AM +0200, Kamil Srot wrote:
> The system is actually management of website&eshop with webbased UI ...
Um, are you sure you don't have a SQL-injection problem, and someone
is doing Something Bad to you?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that tec
On Mon, 2007-08-27 at 21:03 -0500, Erik Jones wrote:
> On Aug 27, 2007, at 8:50 PM, Ow Mun Heng wrote:
>
> > Is it possible to name a primary key (composite) primary key rather
> > than have pg default to table_name_pkey??
> >
> > I tried something like
> >
> > primary key pkey_table_short_form_
Erik Jones <[EMAIL PROTECTED]> writes:
> Also, I'd write a simple "ping" script to check for the table that
> runs every 5 seconds or so.
I had gathered that the table was being touched constantly by his app,
so that it'd be immediately obvious when it had gone away. If that's
not so, then defini
On Aug 27, 2007, at 20:50 , Ow Mun Heng wrote:
Is it possible to name a primary key (composite) primary key rather
than
have pg default to table_name_pkey??
I tried something like
primary key pkey_table_short_form_name (a,b,c)
create table tab (col text, constraint col_is_pkey primary key
On Aug 27, 2007, at 8:50 PM, Ow Mun Heng wrote:
Is it possible to name a primary key (composite) primary key rather
than
have pg default to table_name_pkey??
I tried something like
primary key pkey_table_short_form_name (a,b,c)
but it didnt' work.
Give this a shot:
CONTRAINT pkey_table
On Aug 27, 2007, at 7:57 PM, Kamil Srot wrote:
Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
Erik Jones wrote:
Have you verified that the table's files are still on disk after
it's "disappeared"?
Do not have any idea how to do it... I wasn't able to access it
using any DML/DDL co
Is it possible to name a primary key (composite) primary key rather than
have pg default to table_name_pkey??
I tried something like
primary key pkey_table_short_form_name (a,b,c)
but it didnt' work.
---(end of broadcast)---
TIP 2: Don't 'kill -
Adrian Klaver wrote:
> I have a question. First a little history. Right now, the people who know
> better than I are fairly certain Postgres is not changing things on its own
> and the developer is certain the CMS software is not doing schema changes. As
> I understand it logging has been crank
On Monday 27 August 2007 5:57 pm, Kamil Srot wrote:
> Tom Lane wrote:
> > Kamil Srot <[EMAIL PROTECTED]> writes:
> >> Erik Jones wrote:
> >>> Have you verified that the table's files are still on disk after
> >>> it's "disappeared"?
> >>
> >> Do not have any idea how to do it... I wasn't able to ac
Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
Erik Jones wrote:
Have you verified that the table's files are still on disk after
it's "disappeared"?
Do not have any idea how to do it... I wasn't able to access it using
any DML/DDL commands... can try it on a binary
Kamil Srot <[EMAIL PROTECTED]> writes:
> Erik Jones wrote:
>> Have you verified that the table's files are still on disk after
>> it's "disappeared"?
> Do not have any idea how to do it... I wasn't able to access it using
> any DML/DDL commands... can try it on a binary backup of the damaged DB
Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
From above mentioned duplications of relatio names and what Tom wrote
recently (doesn't see like WA problem), it looks like the relation name
is/gets corrupted in some way and this corruption is internally taken
over to another instanc
brian wrote:
Just wondering: what's the name of this table? What's its function? I
think you mentioned that it's pretty well static. But what is it
holding? Maybe that'll provide a clue as to where to look.
The system is actually management of website&eshop with webbased UI ...
the table is
Erik Jones wrote:
On Aug 27, 2007, at 4:44 PM, Kamil Srot wrote:
Also, in your original post you mentioned a "proprietal CMS
system". Is this proprietary to your company or one that you've
purchased? The fact that the same table going on multiple dbs all
being run by that CMS system certain
Helen <[EMAIL PROTECTED]> writes:
> It's the point that's stored in the table - the query is to find all the
> points within a given box. I'm not sure what that means for indexing though,
> would that mean the point <@ box operator could be used with an index? if
> not, the polygon solution will
Kamil Srot wrote:
brian wrote:
IMHO, it's not at all improbable, given that this software is
connecting to the same databases you are seeing affected by this
phenomenon. Not to mention that it's proprietary, so fewer eyes
have gone over it.[1] I suggested earlier grepping for 'drop' in
your
Andrew Sullivan wrote:
On Mon, Aug 27, 2007 at 11:44:38PM +0200, Kamil Srot wrote:
When this problem appeared for the first time, I had clearly the
wraparound problem... I did vacuum it and partially restored the data...
I don't think vacuum would "fix" a wrap around problem in the wa
On Aug 27, 2007, at 5:29 PM, Matthew wrote:
Hey gang,
I have three possible inputs:
18005551212
+18005551212
8005551212
Right now I am using this to strip off the +, 1, or +1:
INSERT INTO ... VALUES(SUBSTRING(usernumber FROM '^\\+?1?(.*)'));
This works perfect but I get all of thes
Hello Bill,
Bill Moran wrote:
It appears as if I miscommunicated my point. I'm not expecting
PostgreSQL-R to break the laws of physics or anything, I'm just
curious how it reacts. This is the difference between software
that will be really great one day, and software that is great now.
Agree
brian wrote:
Kamil Srot wrote:
> Erik Jones wrote
Also, in your original post you mentioned a "proprietal CMS
system". Is this proprietary to your company or one that you've
purchased? The fact that the same table going on multiple dbs all
being run by that CMS system certainly makes it wo
Owen Hartnett <[EMAIL PROTECTED]> writes:
> I assign the transaction object to each of the commands, but it seems
> that some tables will get updated, even when I call rollback. Is
> something I'm calling secretly calling "commit" somewhere?
Dunno anything about vb.net, but this sounds like an
On 8/27/07, Albe Laurenz <[EMAIL PROTECTED]> wrote:
> Dawid Kuroczko wrote:
> >>> Then again, apart from libpq I don't see it mentioned anywhere.
> [...]
> > Looking at the 8.3devel documentation...
> >
> > I think it should be mentioned in 18. Server Configuration. probably
> > somewhere in 18.3 C
HST <[EMAIL PROTECTED]> writes:
> I am trying to write a query to find all points that fall within a
> given box. However, I cannot seem to find the functionality for
> determining whether a point is within a box.
> e.g. select box '((0,0),(1,1))' @> point '(0.5,0.5)';
> operator does not exist:
On 8/27/07, Kamil Srot <[EMAIL PROTECTED]> wrote:
> I really need to make sure, the next problem (if it's necessary to let
> it happen) will be the last one... :-(
Have you set your log_statement to 'ddl' in postgresql.conf?
That way you'll have a log of every single ddl that goes through the
da
Bill Moran <[EMAIL PROTECTED]> writes:
> In response to Sanjay <[EMAIL PROTECTED]>:
>> Seq Scan on website (cost=0.00..1.31 rows=1 width=162) (actual
>> time=0.047..0.051 rows=1 loops=1)
>> Filter: (website_id = 1)
>> Total runtime: 0.102 ms
>> Wondering why it is not using the index, which woul
"Andrus" <[EMAIL PROTECTED]> writes:
>> The time seems entirely spent in fetching rows from table "rid".
>> Perhaps that table is bloated by lack of vacuuming --- can you
>> show the output from "vacuum verbose rid"?
OK, so the info relevant to this query is
> INFO: index "rid_toode_idx" now con
Hey gang,
I have three possible inputs:
18005551212
+18005551212
8005551212
Right now I am using this to strip off the +, 1, or +1:
INSERT INTO ... VALUES(SUBSTRING(usernumber FROM '^\\+?1?(.*)'));
This works perfect but I get all of these in the log:
WARNING: nonstandard use of \\
On Aug 27, 2007, at 4:44 PM, Kamil Srot wrote:
Also, in your original post you mentioned a "proprietal CMS
system". Is this proprietary to your company or one that you've
purchased? The fact that the same table going on multiple dbs all
being run by that CMS system certainly makes it wort
In response to Markus Schiltknecht <[EMAIL PROTECTED]>:
> Hi,
>
> Bill Moran wrote:
> > I'm curious as to how Postgres-R would handle a situation where the
> > constant throughput exceeded the processing speed of one of the nodes.
>
> Well, what do you expect to happen? This case is easily detec
Kamil Srot <[EMAIL PROTECTED]> writes:
> From above mentioned duplications of relatio names and what Tom wrote
> recently (doesn't see like WA problem), it looks like the relation name
> is/gets corrupted in some way and this corruption is internally taken
> over to another instance of relation
On Mon, Aug 27, 2007 at 11:44:38PM +0200, Kamil Srot wrote:
> When this problem appeared for the first time, I had clearly the
> wraparound problem... I did vacuum it and partially restored the data...
I don't think vacuum would "fix" a wrap around problem in the way you
describe. I don't think
Kamil Srot wrote:
> Erik Jones wrote
Also, in your original post you mentioned a "proprietal CMS system".
Is this proprietary to your company or one that you've purchased? The
fact that the same table going on multiple dbs all being run by that
CMS system certainly makes it worthy of suspic
On 8/23/07, Decibel! <[EMAIL PROTECTED]> wrote:
> On Aug 22, 2007, at 3:37 PM, Joshua D. Drake wrote:
> > You can not do multi master cross continent reliably.
>
> I'm pretty sure that credit card processors and some other companies
> do it... it just costs a LOT to actually do it well.
And most c
Also, in your original post you mentioned a "proprietal CMS system".
Is this proprietary to your company or one that you've purchased? The
fact that the same table going on multiple dbs all being run by that
CMS system certainly makes it worthy of suspicion.
This is software developed in
Bill Moran <[EMAIL PROTECTED]> writes:
First off, "clustering" is a word that is too vague to be useful, so
I'll stop using it.
Right. MySQL Cluster, on the other hand, is a very specific technology.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html
It is, however, capable of being d*
On Aug 27, 2007, at 4:08 PM, Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
# select xmin, age(xmin) from pg_class;
xmin|age
---+
2 | 2147483647
2 | 2147483647
2 | 2147483647
2 | 2147483647
2 | 2147483647
On Mon, Aug 27, 2007 at 12:48:34PM -0800, Matthew Schumacher wrote:
> When inserting a float such as 4.12322345 into a int column postgres
> inserts 4 instead of returning an error telling you that your value
> won't fit. I would much rather have the error and check for it since I
> can be sure I'
Matthew Schumacher <[EMAIL PROTECTED]> writes:
> template1=# create table test (number int);
> CREATE TABLE
> template1=# insert into test (number) values (4.123123123);
> INSERT 0 1
Perhaps you'd be happier doing it like this:
regression=# insert into test (number) values ('4.123123123');
ERROR:
Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
# select xmin, age(xmin) from pg_class;
xmin|age
---+
2 | 2147483647
2 | 2147483647
2 | 2147483647
2 | 2147483647
2 | 2147483647
2 | 2147483647
23683801
> --- Original Message ---
> From: Dizzy <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 27/08/07, 21:12:55
> Subject: [GENERAL] pgsql Windows installer fixed registry key
>
> The pgsql MSI installer does register a registry key but it's random
> everytime
> it installs
> --- Original Message ---
> From: "Stephen Ince" <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 27/08/07, 21:30:06
> Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished
>
> Dave,
>Thx I will take a look. I was trying to port a postgres schema
Kamil Srot <[EMAIL PROTECTED]> writes:
> # select xmin, age(xmin) from pg_class;
>xmin|age
> ---+
> 2 | 2147483647
> 2 | 2147483647
> 2 | 2147483647
> 2 | 2147483647
> 2 | 2147483647
> 2 | 2147483647
> 236838019
List,
One of the reasons why I use postgres is because you can insert data and
it will work or give you an error instead of converting, truncating,
etc... well I found a place where postgres makes an erroneous
assumption and I'm not sure this is by design.
When inserting a float such as 4.1232234
Andrew Sullivan wrote:
I can easily rewrite it to use the vacuumdb command, but I doubt it'll
make any difference.
The point is that you don't have to rewrite it. Just run "vacuumdb
-a" and it vacuums _all_ databases.
Oh, I have it now! It takes some time, but at the end, I'll unders
There are some limitations to SQL Server Express:
http://www.microsoft.com/sql/downloads/trial-software.mspx
Download SQL Server 2005 Express Edition
Complete a SQL Server Express download, free. There are no time limits
and the software is freely redistributable (with registration). With a
databa
Hello
I am currently working on creating a build system for an open source portable
project that should be able to build the project on many platforms, POSIX and
non-POSIX such as Windows. Our project has the option for using PostgreSQL.
Searching for PostgreSQL includes/libraries is very easy
On Mon, Aug 27, 2007 at 10:31:11PM +0200, Kamil Srot wrote:
> The script is very simple one:
Well, I don't see anything obvious, but. . .
> I can easily rewrite it to use the vacuumdb command, but I doubt it'll
> make any difference.
The point is that you don't have to rewrite it. Just run "va
Yes, but fortunately for me, unfortunately for the list, it's only
happened to me once so I don't really have anything to go on wrt
repeating the problem. I can only say, "Yep! It's happened!" I am
watching my db closely, though. Well, my monitoring scripts are :)
On Aug 27, 2007, at 1:
Dave,
Thx I will take a look. I was trying to port a postgres schema to a
database that had embedded capability. I could not find any non-commerical
databases that supported triggers, sequences, udf function, and stored
procedure. I as I remembered firebird has pretty weak UDF function
capab
Andrew Sullivan wrote:
On Mon, Aug 27, 2007 at 10:03:04PM +0200, Kamil Srot wrote:
Sure, I ment it like I'll do the FULL vacuum less often than daily and
do daily the plain vacuum command.
If you have your servers set up correctly, you should never need to
perform VACUUM FULL.
Andrew Sullivan wrote:
>On Mon, Aug 27, 2007 at 02:00:02PM +0300, Andrus wrote:
>> Postgres log files are polluted with messages
>>
>> 2007-08-27 06:10:38 WARNING: nonstandard use of \\ in a string literal at
>> character 190
>> 2007-08-27 06:10:38 HINT: Use the escape string syntax for backsl
On Mon, Aug 27, 2007 at 10:03:04PM +0200, Kamil Srot wrote:
> >
> Sure, I ment it like I'll do the FULL vacuum less often than daily and
> do daily the plain vacuum command.
If you have your servers set up correctly, you should never need to
perform VACUUM FULL.
> Well, I do list all database
Point taken for the enterprise comparison. The reason for having the
embedded database is to hide the complexity for installing, using, and
configuration of the database from the user of the application. You don't
want a scaled version of the database.
- Original Message -
From: "T
Andrew Sullivan wrote:
On Mon, Aug 27, 2007 at 07:15:44PM +0200, Kamil Srot wrote:
OK, I'll drop the full part and do it less often...
This doesn't address your problem, but when you move from VACUUM FULL
to VACUUM, you want to do it _more_ often, not less.
Sure, I ment it like I'l
I have setup a Postgres server on Debian Etch and successfully connected
to it with various *nix clients but I now have to connect a WinXP
client. On accessing the Postgres site I am directed to a download page,
click on the appropriate link and get automatically directed to a
University of Kent si
Maybe someone here can figure it out. Everything updates fine with
this code, except where there's an exception, it's not rolling back
by the transaction. What I'm trying to do:
Begin a transaction
Do the update, insert, delete checks on each of the data tables,
using a different npgsqlcom
On Mon, Aug 27, 2007 at 02:00:02PM +0300, Andrus wrote:
> Postgres log files are polluted with messages
>
> 2007-08-27 06:10:38 WARNING: nonstandard use of \\ in a string literal at
> character 190
> 2007-08-27 06:10:38 HINT: Use the escape string syntax for backslashes,
> e.g., E'\\'.
That's
On Mon, Aug 27, 2007 at 07:15:44PM +0200, Kamil Srot wrote:
> OK, I'll drop the full part and do it less often...
This doesn't address your problem, but when you move from VACUUM FULL
to VACUUM, you want to do it _more_ often, not less.
But given what you've posted, I am not even a little bit con
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
>
> The machine we are tracking this problem on is also 64bit.
H.looks like 3 different people are tracking a similar issue on 64 bit
platforms.you,
Erik and myself.
_
On Mon, Aug 27, 2007 at 12:08:17PM -0400, Jonah H. Harris wrote:
> On 8/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Indeed. In fact, the most likely implementation of this (refuse to do
> > anything with a page with a bad CRC) would be a net loss from that
> > standpoint, because you couldn't g
On Monday 27 August 2007 05:21, Sanjay <[EMAIL PROTECTED]> wrote:
>Wondering why it is not using the index, which would have
> been
> automatically created for the primary key.
Because you not only have just one row in the whole table, 100% of them will
match the query. In short, one page fetch f
In response to Sanjay <[EMAIL PROTECTED]>:
> Hi All,
>
> Say I have a simple table WEBSITE(website_id int4 PRIMARY KEY, name
> VARCHAR(30)). While I try this:
>
> EXPLAIN ANALYZE SELECT * FROM WEBSITE WHERE website_id = 1
>
> the output is:
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
>
> On Aug 27, 2007, at 12:15 PM, Martijn van Oosterhout wrote:
>
>> On Mon, Aug 27, 2007 at 09:12:17AM -0700, Jeff Amiel wrote:
>>> Tracking for last few days.
>>> Does not appear to happen when little or no user
>>> activity (like
Hello,
We tried many things but didnt succeed.
Our DB crashed without any recent backup.
We have 3 elements:
- a backup we did in February,
- 4 WAL files in the pg_xlog folder created in august,
- the base folder (in which there are table files created in august)
Q1 : Is it possible to cop
Hello
I am trying to write a query to find all points that fall within a
given box. However, I cannot seem to find the functionality for
determining whether a point is within a box.
e.g. select box '((0,0),(1,1))' @> point '(0.5,0.5)';
operator does not exist: box @> point
Is this operator for
Hi,
Does the psql's \copy command run as a transaction? I think it does, but
somehow when I cancel (in a script) a running import, "seems" (I can't
seem to duplicate it on the cli though) like a few lines/rows gets
inserted anyway..
---(end of broadcast)-
Hi All,
Say I have a simple table WEBSITE(website_id int4 PRIMARY KEY, name
VARCHAR(30)). While I try this:
EXPLAIN ANALYZE SELECT * FROM WEBSITE WHERE website_id = 1
the output is:
--
Seq Scan on website (cost=
I'm using PostgreSQL PostgreSQL 8.2.4 from ODBC 08.02.0300 client.
Postgres log files are polluted with messages
2007-08-27 06:10:38 WARNING: nonstandard use of \\ in a string literal at
character 190
2007-08-27 06:10:38 HINT: Use the escape string syntax for backslashes,
e.g., E'\\'.
2007-
> Perhaps that table is bloated by lack of vacuuming --- can you
> show the output from "vacuum verbose rid"?
Thank you.
After running vacuum and analyze commands the query takes 18 seconds.
This is still very slow because my tables are indexed.
How to speed up this ?
set search_path to firma1,p
> The time seems entirely spent in fetching rows from table "rid".
> Perhaps that table is bloated by lack of vacuuming --- can you
> show the output from "vacuum verbose rid"?
INFO: vacuuming "firma1.rid"
INFO: scanned index "rid_pkey" to remove 7375 row versions
DETAIL: CPU 0.01s/0.39u sec el
Stephen Ince wrote on 27.08.2007 18:02:
Derby and hsqldb are the only free embedded databases for commercial use.
Well, there are some more:
H2 Database, OneDollarDB (OpenSource version of DaffodilDB), Berkely DB and
McKoi are free as well (although McKoi seems to be dead).
Then there are a
Alvaro Herrera wrote:
Kamil Srot wrote:
Martijn van Oosterhout wrote:
On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
postgres $db for each database...
Hope it's correct?
Well, I'd
Kamil Srot wrote:
>
> Martijn van Oosterhout wrote:
>> On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
>>
>>> Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
>>> postgres $db for each database...
>>> Hope it's correct?
>>>
>>
>> Well, I'd drop the "full" part
Has anyone come across this error before?
LOG: PickSplit method of 2 columns of index
'asset_position_lines_asset_cubespacetime_idx' doesn't support secondary
split
This is a multi-column GiST index on an integer and a cube (a data type
from the postgres cube extension module).
I traced t
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
Tom Lane committed:
- Restrict pg_relation_size to relation owner, pg_database_size to DB
owner, and pg_tablespace_size to superusers. Perhaps we could
weaken the first case to just require SELECT privilege, but that
doesn't work for the othe
On 8/27/07, Stephen Ince <[EMAIL PROTECTED]> wrote:
> I recently ported a schema from postgres to firebird and found name size
> limitations. Firebird has a limitation on the size of it's column names,
> table names, constraint names and index names. I think the size limitation
> on firebird is 31
On Aug 27, 2007, at 12:15 PM, Martijn van Oosterhout wrote:
On Mon, Aug 27, 2007 at 09:12:17AM -0700, Jeff Amiel wrote:
Tracking for last few days.
Does not appear to happen when little or no user
activity (like Saturday) I don't know if that rules
out autovacuum or not (if no update threshho
On Mon, Aug 27, 2007 at 09:12:17AM -0700, Jeff Amiel wrote:
> Tracking for last few days.
> Does not appear to happen when little or no user
> activity (like Saturday) I don't know if that rules
> out autovacuum or not (if no update threshholds are
> reached, no vacuuming will take place anyway)
Martijn van Oosterhout wrote:
On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
postgres $db for each database...
Hope it's correct?
Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
you c
> --- Original Message ---
> From: "Stephen Ince" <[EMAIL PROTECTED]>
> To: "Tony Caduto" <[EMAIL PROTECTED]>, "Greg Smith" <[EMAIL PROTECTED]>,
> pgsql-general@postgresql.org
> Sent: 27/08/07, 17:02:21
> Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished
>
> Post
On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
> Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
> postgres $db for each database...
> Hope it's correct?
Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
you check it was actually completing (no e
On Aug 27, 2007, at 11:47 , Tony Caduto wrote:
Good call on the name limit, I remember running into that when
porting something from MS SQL server to Firebird about 4 years ago.
Just a quick note: PostgreSQL's identifiers are limited to
NAMEDATALEN - 1 (IIRC), which by default is 64 - 1 =
Martijn van Oosterhout wrote:
On Mon, Aug 27, 2007 at 06:37:17PM +0200, Kamil Srot wrote:
I don't say, it's gone by itself, I'm asking for help debuging this
situation and hopefully find a solution. For the first time it happened,
it had the same symptoms - this specific table was missing an
Jeff Amiel <[EMAIL PROTECTED]> writes:
> Tracking for last few days.
> Does not appear to happen when little or no user
> activity (like Saturday) I don't know if that rules
> out autovacuum or not (if no update threshholds are
> reached, no vacuuming will take place anyway)
Can you correlate the
On Mon, Aug 27, 2007 at 06:37:17PM +0200, Kamil Srot wrote:
> I don't say, it's gone by itself, I'm asking for help debuging this
> situation and hopefully find a solution. For the first time it happened,
> it had the same symptoms - this specific table was missing and
> transaction counter was
Stephen Ince wrote:
Postgres can't be embedded or serverless. Firebird has the embedded
feature. Most of the databases have this capability (hsqldb,
derby,oracle,mysql, firebird, and db2). Derby and hsqldb are the only
free embedded databases for commercial use.
A lot of Firebird users have
brian wrote:
Tom Lane wrote:
Kamil Srot <[EMAIL PROTECTED]> writes:
One more thing:
The project runs proprietal CMS system and there are more instances
of it with the same database layout in different databases. Every
time the "lost" table is the same one - the bussiest one (mostly
read)..
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes:
> I know that this PostgreSQL C module has a static var that in turn keeps the
> integer set by the function "set_session_id" - but is this var global to the
> server's service ? Does PostgreSQL mantain one "instance" of this var per
> requeste
On 8/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> Indeed. In fact, the most likely implementation of this (refuse to do
> anything with a page with a bad CRC) would be a net loss from that
> standpoint, because you couldn't get *any* data out of a page, even if
> only part of it had been zapped.
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> We are actually diagnosing a similar problem on this
> end, where we get a
> failure at 1920... I am currently trying to get some
> DEBUG output.
Tracking for last few days.
Does not appear to happen when little or no user
activity (like Saturday
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Jeff Amiel <[EMAIL PROTECTED]> writes:
> > is log_min_messages one of them that requires a
> > restart?
>
> No, SIGHUP (pg_ctl reload) should be sufficient.
Weird
looks like some items are going to syslog and some to
my defined postgres logfile (from
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Jeff Amiel <[EMAIL PROTECTED]> writes:
> > is log_min_messages one of them that requires a
> > restart?
>
> No, SIGHUP (pg_ctl reload) should be sufficient.
Weird
looks like some items are going to syslog and some to
my defined postgres logfile (from
Postgres can't be embedded or serverless. Firebird has the embedded feature.
Most of the databases have this capability (hsqldb, derby,oracle,mysql,
firebird, and db2). Derby and hsqldb are the only free embedded databases
for commercial use.
I recently ported a schema from postgres to firebir
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> Joseph S <[EMAIL PROTECTED]> writes:
>>> Tom Lane committed:
>>> - Restrict pg_relation_size to relation owner, pg_database_size to DB
>>> owner, and pg_tablespace_size to superusers. Perhaps we could
>>> weaken the first case to jus
On Aug 27, 2007, at 11:04 AM, Andrew Sullivan wrote:
It was a way to scale many small systems for certain kinds of
workloads. My impression is that in most cases, it's a SQL-ish
solution to a problem where someone decided to use the SQL nail
because that's the hammer they had. I can think of
1 - 100 of 139 matches
Mail list logo
