Tommy Flewwelling wrote:
Could someone tell me if the ‘--pwfile’ command can be
applied to createdb.exe and psql.exe?
No, but you can use the libpq password file. See
http://www.postgresql.org/docs/current/static/libpq-pgpass.html
Yours,
Laurenz Albe
---(end of
Il Wednesday 07 November 2007 07:54:41 Reg Me Please ha scritto:
Il Wednesday 07 November 2007 01:29:44 Alvaro Herrera ha scritto:
Reg Me Please wrote:
Il Tuesday 06 November 2007 22:13:15 hai scritto:
That's the branch and bound. Editing 29M+ lines file takes some time.
But this is
Il Wednesday 07 November 2007 11:10:40 Dimitri Fontaine ha scritto:
Le mercredi 07 novembre 2007, Reg Me Please a écrit :
pgloader seems not that easy to use for a newbie like myself.
Also because domentation seems too skinny.
Sorry about this, writting documentation in English is not that
Le mercredi 07 novembre 2007, Reg Me Please a écrit :
pgloader seems not that easy to use for a newbie like myself.
Also because domentation seems too skinny.
Sorry about this, writting documentation in English is not that easy when it's
not one's natural language... I'll accept any
Il Wednesday 07 November 2007 11:26:56 Dimitri Fontaine ha scritto:
Le mercredi 07 novembre 2007, Reg Me Please a écrit :
Maybe just a complete example would suffice. Let's say a table structure,
a CSV and a raw text file, a config file and the run output.
Do you mean something like the
Le mercredi 07 novembre 2007, Reg Me Please a écrit :
Maybe just a complete example would suffice. Let's say a table structure, a
CSV and a raw text file, a config file and the run output.
Do you mean something like the included examples, which I tend to also use as
(regression) tests?
Hi all,
When my application returns errors from database, some numbers errors is
equals.
Why number errors is equals? odbc driver or postgresql return this?
It's run in Windows.
Thanks.
---(end of broadcast)---
TIP 5: don't forget to increase
Il Tuesday 06 November 2007 19:05:52 Reg Me Please ha scritto:
Hi all.
I'm generating an SQL script to load some million rows into a table.
I'm trying to use the COPY command in order to speed the load up.
At a certain point I get an error telling about a
invalid input syntax for type
Reid Thompson escreveu:
On Tue, 2007-11-06 at 14:39 -0300, André Volpato wrote:
Remember that you can always use serial fields to count a table, like:
alter table foo add id serial;
select id from foo order by id desc limit 1;
This should return the same value than count(*), in
Il Wednesday 07 November 2007 13:08:46 André Volpato ha scritto:
!DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
meta content=text/html;charset=UTF-8 http-equiv=Content-Type
title/title
/head
body bgcolor=#ff text=#00
Reid Thompson escreveu:
Would it be
Le mercredi 07 novembre 2007, Reg Me Please a écrit :
I installed .deb. The man page has not been included.
It seems the latter package on pgfoundry does have a problem here. As I have
some patches waiting for a release, I'll make current CVS the 2.2.2 version
and update the pgfoundry files
On Tue, 2007-11-06 at 09:29 -0500, Bill Moran wrote:
In response to SHARMILA JOTHIRAJAH [EMAIL PROTECTED]:
Hi
We are in the process of testing for migration of our database from Oracle
to Postgresql.
I hava a simple query
Select count(*) from foo
This is asked a lot. The quick
On Tue, 2007-11-06 at 09:48 -0500, Tom Lane wrote:
Essentially the same text appears in SQL2003. Any application that
depends on one particular choice here is therefore broken, or at least
has chosen to work with only about half of the DBMSes in the world.
If an application has already made
Hello,
If you use ODBC - you should devide error from ODBC driver and errors
from PostgreSQL, ODBC driver return it's own error codes, and composes
error Description depending on Error Code and Text from PostgreSQL
server. So you should have numbers:
1) ODBC error code - described in MSDN;
Hi, I'm planning to use prepared statements of indefinite lifetime in a
daemon that will execute same statements rather frequently in reply to
client requests.
This link:
http://www.postgresql.org/docs/8.3/static/sql-prepare.html
has a note on performance:
In some situations, the query plan
Christian Schröder wrote:
Alvaro Herrera wrote:
Please try thread apply all bt full on gdb.
The first lines where the symbols are loaded are of course identical. The
output of the command is in my opinion not very helpful:
I was actually hoping that it would list the running threads in
Il Wednesday 07 November 2007 12:25:46 rihad ha scritto:
I don't understand why postgres couldn't plan this:
SELECT foo.e, foo.f
FROM foo
WHERE pk=$1 AND b=$2 AND status='1' AND c = $3;
to be later executed any slower than
SELECT foo.e, foo.f
FROM foo
WHERE pk='abcabc' AND b='13' AND
On Tue, 2007-11-06 at 15:53 -0500, Marc wrote:
Ok. I'll keep looking at pg_locks.
My original reason for reaching out to the list was over confusion as
to when an EXCLUSIVE lock would be taken table level since the
documentation says this should never happen except to some system
rihad wrote:
Hi, I'm planning to use prepared statements of indefinite lifetime in a
daemon that will execute same statements rather frequently in reply to
client requests.
This link:
http://www.postgresql.org/docs/8.3/static/sql-prepare.html
has a note on performance:
In some situations,
Nick Johnson [EMAIL PROTECTED] writes:
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
select create_date from article_lead;
create_date
---
2007-11-04 16:35:33.17+00
2007-11-04 04:35:36.09+00
2007-11-05 04:35:36.38+00
2007-11-05
Tom Lane [EMAIL PROTECTED] writes:
Simon Riggs [EMAIL PROTECTED] writes:
Perhaps we can have a parameter?
default_null_sorting = 'last' # may alternatively be set to 'first'
Not unless it's locked down at initdb time. Otherwise flipping the
value bars you from using every existing index
Tommy Flewwelling wrote:
Hello,
How do I specify in the command-line to access the .pgpass file when
creating a database?
You don't. If the file exists and has the correct permission, createdb
will read it. If the needed password is found, the connection will be
done without ever
On 11/7/07, Gauthier, Dave [EMAIL PROTECTED] wrote:
Yes, I'm thinking of a small DB (could fit into mem). And the notion
that all the data would reside in memory makes sense. But what about
the metadata? And there is the question of the initdb and all the
stuff it creates. That goes to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/07/07 11:35, Andrej Ricnik-Bay wrote:
On 11/8/07, Collin Kidder [EMAIL PROTECTED] wrote:
[snip]
No, just not everyone agrees with your viewpoint on this topic. Top
posting has it's place and some of us prefer it.
But they could just
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Undo an initdb? Probably the same way you undo unlinking an SQLite
database.
Maybe being wrapped in my own little niche I just don't know enough
about the wide world of hyperfeaturitis, but making temporary DB
as a feature seems a little vague.
It
Collin Kidder wrote:
I'm with Thomas. I think that, while inline posting is a good thing,
bottom posting is dead stupid and wastes my time. It is far easier to
follow a thread with top posting as the relevant text is right there at
the top ready to be read.
That sounds more like an argument
On Wed, 2007-11-07 at 11:39 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Wed, 2007-11-07 at 10:23 -0500, Tom Lane wrote:
I put this in the same category as altering the identifier case-folding
rules.
That has much less effect on application portability,
Really?
Nick Johnson wrote:
Before I open a bug on this, I wanted to do a sanity check, since there
may be something I'm just not seeing.
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
select create_date from article_lead;
create_date
---
My point is: with top-posting I don't care how many lines were repeated
because I don't have to scroll.
Considering there is an RFC that recommends inline posting over
top-posting (http://tools.ietf.org/html/rfc1855), and considering the
fact that this topic has been beat to death on
rihad [EMAIL PROTECTED] writes:
Aha, thanks for a thorough explanation. Now I understand that while
looking for a way to fulfill the query postgres will try hard to pick
the one requiring the least number of rows visits. I've skimmed over my
queries: almost all of them make use of the
Before I open a bug on this, I wanted to do a sanity check, since there
may be something I'm just not seeing.
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
select create_date from article_lead;
create_date
---
2007-11-04 16:35:33.17+00
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/07/07 09:58, Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
On 11/07/07 09:03, Gauthier, Dave wrote:
Is there such a thing as a temporary, probably in-memory, version of a
Postgres DB?
If you have enough RAM, and your database is
Am Mittwoch, 7. November 2007 schrieb Tommy Flewwelling:
How do I inform the complier to extract the password from the file and not
the prompt the user?
It does that automatically. Just omit the -W option.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
On 11/7/07, Karsten Hilbert [EMAIL PROTECTED] wrote:
On Wed, Nov 07, 2007 at 03:54:02PM +0100, Martijn van Oosterhout wrote:
Should I be going about this sorting or hashing or detection
business in another way entirely which can be done at the
SQL level ?
I'm wondering if you cast
Tommy Flewwelling [EMAIL PROTECTED] writes:
How do I specify in the command-line to access the .pgpass file when creating
a database?
Huh? You don't specify anything, it's done automatically when needed.
I dont want to have to include (-W):
C:\postgressql\bincreatedb -U postgres p 5432
Ron Johnson [EMAIL PROTECTED] writes:
On 11/07/07 09:03, Gauthier, Dave wrote:
Is there such a thing as a temporary, probably in-memory, version of a
Postgres DB?
If you have enough RAM, and your database is small enough, the OS
will eventually cache the whole thing.
Or put it on a ramdisk
On Wed, 2007-11-07 at 16:05 +0100, Martijn van Oosterhout wrote:
On Wed, Nov 07, 2007 at 02:37:41PM +, Simon Riggs wrote:
Editing an application, you would be required to add the words NULLS
FIRST to every single ORDER BY and every single CREATE INDEX in an
application. If we know that
Hello,
This query works for me on Access 2003. Which versions of Access and
ODBCng you have?
We can communicate via [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]. I'll try to help you with any
problems.
Sam Mason wrote:
On Tue, Nov 06, 2007 at 05:48:12PM -0300, Alvaro Herrera wrote:
FYI
This is a real longshot, but here goes...
Is there such a thing as a temporary, probably in-memory, version of a
Postgres DB? Sort of like SQLite, only with the features/function of
PG? A DB like this would exist inside of, and for the duration of, a
script/program that created it, then
Hello,
How do I specify in the command-line to access the .pgpass file when creating a
database?
I would like to use ~/.pgpass instead of –W on the command line when creating a
database (createdb) and was wondering the correct syntax.
For example,
I don’t want to have to include
On Wed, Nov 07, 2007 at 02:37:41PM +, Simon Riggs wrote:
Editing an application, you would be required to add the words NULLS
FIRST to every single ORDER BY and every single CREATE INDEX in an
application. If we know that is what people would do, why not have one
parameter to do this for
On Wed, 2007-11-07 at 08:38 -0500, Bruce Momjian wrote:
Simon Riggs wrote:
If an application has already made that choice then we should allow them
the opportunity to work with PostgreSQL. The application may be at
fault, but PostgreSQL is the loser because of that decision.
The SQL
rihad [EMAIL PROTECTED] writes:
I don't understand why postgres couldn't plan this:
SELECT foo.e, foo.f
FROM foo
WHERE pk=$1 AND b=$2 AND status='1' AND c = $3;
to be later executed any slower than
SELECT foo.e, foo.f
FROM foo
WHERE pk='abcabc' AND b='13' AND status='1' AND c =
Alvaro Herrera wrote:
Rainer Bauer wrote:
Andrej Ricnik-Bay wrote:
On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote:
That's nice to hear. But I respect licences as they are and the ODBCng
driver
is licenced under the GPL.
That doesn't mean that you're not allowed to use
Hi,
in GNUmed (wiki.gnumed.de) we use schema hashing to detect
whether a database can safely be upgraded or used by a
client. The general procedure is this:
- generate a line-by-line representation of the database
objects in the format schema.table.column::data type
from the information
Reg Me Please wrote:
P.S.
Why not including the pgloader into the main tarball?
We are not attempting to include every useful tool in the database
server. We're actually moving in the opposite direction: stuff has been
offloaded to pgfoundry as appropriate. Add-on packages are encouraged.
If
Il Wednesday 07 November 2007 13:47:26 SHARMILA JOTHIRAJAH ha scritto:
Hi
we are testing with version PostgreSQL 8.2.3.
Why not using at least the current 8.2.5?
Read here
http://www.postgresql.org/docs/current/static/release.html
for details.
--
Reg me Please
Hi,
I'm seeing an EXCLUSIVE lock being taken on a table even though the
documentation says that This lock mode is not automatically acquired on
user tables by any PostgreSQL command.
My SQL is
UPDATE users SET online = $1 where username = $2
username is the PK on the users table.
Other locks
Version of postgres is 8.2.4.
Maybe it will help to give more b/g on how I'm identifying the problem?
The way this materializes as a real issue surrounds transactions left idle.
There is a bug in our app that we haven't tracked down yet where on occasion
we end up with connections marked IDLE in
On 11/7/07, Tom Lane [EMAIL PROTECTED] wrote:
A more general objection is that causing query semantics to change in
subtle ways based on a GUC variable has more often than not proven to be
a bad idea.
On top of that, this is another one of those conversations that
basically are predicated on
In response to Gauthier, Dave [EMAIL PROTECTED]:
One question I had earlier that I don't think got answered was how to
undo an initdb. dropdb drops a DB, but how do I undo an initdb?
rm -rf the directory in which you put the initdb.
--
Bill Moran
http://www.potentialtech.com
Sascha Bohnenkamp wrote:
Is there a list postgres related unexpected 'features', like count(*) is
expensive etc.?
I do not ask to bash postgres, but to use it ... and it would be nice if
I have not to try any pittfall by myself.
Something like http://sql-info.de/postgresql/postgres-gotchas.html?
Tom Lane wrote:
rihad [EMAIL PROTECTED] writes:
I don't understand why postgres couldn't plan this:
SELECT foo.e, foo.f
FROM foo
WHERE pk=$1 AND b=$2 AND status='1' AND c = $3;
to be later executed any slower than
SELECT foo.e, foo.f
FROM foo
WHERE pk='abcabc' AND b='13' AND status='1'
Simon Riggs [EMAIL PROTECTED] writes:
On Wed, 2007-11-07 at 10:23 -0500, Tom Lane wrote:
I put this in the same category as altering the identifier case-folding
rules.
That has much less effect on application portability,
Really? Try counting the number of requests for that in the
Simon Riggs wrote:
On Wed, 2007-11-07 at 16:05 +0100, Martijn van Oosterhout wrote:
On Wed, Nov 07, 2007 at 02:37:41PM +, Simon Riggs wrote:
Editing an application, you would be required to add the words NULLS
FIRST to every single ORDER BY and every single CREATE INDEX in an
application.
On Wed, Nov 07, 2007 at 05:36:47PM +0200, Marko Kreen wrote:
I'm wondering if you cast the md5sum as a bytea instead of text and
then sort, if that would solve it simply.
Along the lines of
... ORDER BY decode(md5('...'), 'hex');
Maybe using digest(.., 'md5') function
Yes, I'm thinking of a small DB (could fit into mem). And the notion
that all the data would reside in memory makes sense. But what about
the metadata? And there is the question of the initdb and all the
stuff it creates. That goes to disk, yes? no?
Another question, but first my tenuous
On Wed, Nov 07, 2007 at 03:42:11PM +0100, Karsten Hilbert wrote:
Should I be going about this sorting or hashing or detection
business in another way entirely which can be done at the
SQL level ?
I'm wondering if you cast the md5sum as a bytea instead of text and
then sort, if that would
Andrej Ricnik-Bay wrote:
On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote:
That's nice to hear. But I respect licences as they are and the ODBCng driver
is licenced under the GPL.
That doesn't mean that you're not allowed to use it with commercial
applications; it just means that
Rainer Bauer wrote:
Alvaro Herrera wrote:
Rainer Bauer wrote:
Andrej Ricnik-Bay wrote:
On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote:
That's nice to hear. But I respect licences as they are and the ODBCng driver
is licenced under the GPL.
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
Not unless it's locked down at initdb time. Otherwise flipping the
value bars you from using every existing index ... including those
on the system catalogs ... which were made with the other setting.
Surely if we
Rainer Bauer wrote:
Andrej Ricnik-Bay wrote:
On Nov 7, 2007 2:40 PM, Rainer Bauer [EMAIL PROTECTED] wrote:
That's nice to hear. But I respect licences as they are and the ODBCng
driver
is licenced under the GPL.
That doesn't mean that you're not allowed to use it with commercial
Ron Johnson [EMAIL PROTECTED] writes:
On 11/07/07 09:58, Tom Lane wrote:
Or put it on a ramdisk filesystem.
But doesn't that just add more overhead and reduce the amount of
memory that the OS can cache things in?
It's very possibly not a win, but the kinds of people who ask this
question at
On 11/7/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/07/07 09:58, Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
On 11/07/07 09:03, Gauthier, Dave wrote:
Is there such a thing as a temporary, probably in-memory, version of a
On Wed, 2007-11-07 at 10:23 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Perhaps we can have a parameter?
default_null_sorting = 'last' # may alternatively be set to 'first'
Not unless it's locked down at initdb time. Otherwise flipping the
value bars you from using every
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/07/07 09:03, Gauthier, Dave wrote:
This is a real longshot, but here goes...
Is there such a thing as a temporary, probably in-memory, version of a
Postgres DB? Sort of like SQLite, only with the features/function of
PG? A DB like
Hi,
About a month or so ago I read a blog entry or an article which seems to
have described a method, using dirty hackery with pg_resetxlog and
possibly other tools, to forcibly undo the database to a previous
state. The problem described was that some employee had executed a
DELETE or UPDATE
On Wed, 7 Nov 2007, Rainer Bauer wrote:
The way I read this section is that linking to a GPL ODBC driver would imply
that I have to release my program under a GPL (compatible) licence.
What you actually link against is the ODBC implementation for your
platform. If you're on something
Hi,
The table has 43 columns. I have attached the columns-list.They have many
char() and numeric columns.
For the table size, these are the corresponding entries from the pg_class
foo is the table and the others are some of its indexes.
relname reltuples relpages
foo
Thanks. I have tried your program. But it seems that it has trouble with
EUC_CN.
It returns unrecoginzed value of empty columns.
BTW: I've solved this problem. Every one using odbc on windows shuold read
this mail:
psqlODBC with Visual Studio 2005 and Connection Pooling for
Hi
we are testing with version PostgreSQL 8.2.3. We already have a production
system in Oracle and we wanted to migrate it to postgresql. If some tests are
already done, are the results available for us to see?
Ill also check postgres 8.3 beta.
Thanks again
Sharmila
- Original Message
Simon Riggs wrote:
If an application has already made that choice then we should allow them
the opportunity to work with PostgreSQL. The application may be at
fault, but PostgreSQL is the loser because of that decision.
The SQL Standard says that the default for this is defined by the
In response to Thomas Kellerer [EMAIL PROTECTED]:
Tom Lane, 07.11.2007 06:14:
Thomas Kellerer [EMAIL PROTECTED] writes:
If everyone simply top-posted, there would be no need for me to scroll
down,
just to find a two line answer below a forty line quote - which I
personally
find
Hi all,
When my application returns errors from database, some numbers errors
is
equals.
Why number errors is equals? odbc driver or postgresql return this?
It's run in Windows.
Thanks.
Hello,
If you use ODBC - you should devide error from ODBC driver and errors
from PostgreSQL, ODBC
On Tue, Nov 06, 2007 at 05:48:12PM -0300, Alvaro Herrera wrote:
FYI there's another Postgres ODBC driver that is said to have better
performance.
https://projects.commandprompt.com/public/odbcng
(Yes, my company maintains it)
Are there any known issues when calling it from VB? I've got a
On 11/8/07, Collin Kidder [EMAIL PROTECTED] wrote:
I'm with Thomas. I think that, while inline posting is a good thing,
bottom posting is dead stupid and wastes my time.
Just as bad as top-posting, really.
It is far easier to
follow a thread with top posting as the relevant text is right
I understand caching.
Here's the reason I'm inquiring into this line of thought...
I already have a big on-disk DB with lots and lots of data, and lots
of stored functions and a data model that works with DB loaders and
other code that queries out data. I also have users that want all of
that,
On Wed, 7 Nov 2007, Tom Lane wrote:
Nick Johnson [EMAIL PROTECTED] writes:
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
[snip]
Shouldn't that second row have been in the results of the second query?
Huh? Those results look perfectly sane to me.
Ah, you're
Simon Riggs [EMAIL PROTECTED] writes:
Perhaps we can have a parameter?
default_null_sorting = 'last' # may alternatively be set to 'first'
Not unless it's locked down at initdb time. Otherwise flipping the
value bars you from using every existing index ... including those
on the system
On 11/7/07, Gauthier, Dave [EMAIL PROTECTED] wrote:
This is a real longshot, but here goes...
Is there such a thing as a temporary, probably in-memory, version of a
Postgres DB? Sort of like SQLite, only with the features/function of PG? A
DB like this would exist inside of, and for the
Greg Smith wrote:
On Wed, 7 Nov 2007, Rainer Bauer wrote:
The way I read this section is that linking to a GPL ODBC driver would imply
that I have to release my program under a GPL (compatible) licence.
What you actually link against is the ODBC implementation for your
platform. If you're
rihad wrote:
Hi, I'm planning to use prepared statements of indefinite
lifetime in a daemon that will execute same statements
rather frequently in reply to client requests.
This link:
http://www.postgresql.org/docs/8.3/static/sql-prepare.html
has a note on performance:
In some
On Wed, Nov 07, 2007 at 03:54:02PM +0100, Martijn van Oosterhout wrote:
Should I be going about this sorting or hashing or detection
business in another way entirely which can be done at the
SQL level ?
I'm wondering if you cast the md5sum as a bytea instead of text and
then sort, if
Once again, I'm trying to translate my knowledge of Informix to
PostgreSQL. I tried the manual and Google, but could not find anything
relevant.
Informix keeps transaction logs in a dedicated, pre-allocated disk
area that, until very recent versions, could not grow dynamically. It
is the DBA's
Jeff Larsen [EMAIL PROTECTED] writes:
Informix keeps transaction logs in a dedicated, pre-allocated disk
area that, until very recent versions, could not grow dynamically. It
is the DBA's responsibility to continually backup these transaction
logs so the space may be recycled. As such,
Ivan Voras [EMAIL PROTECTED] writes:
About a month or so ago I read a blog entry or an article which seems to
have described a method, using dirty hackery with pg_resetxlog and
possibly other tools, to forcibly undo the database to a previous
state. The problem described was that some employee
On 07/11/2007, Tom Lane [EMAIL PROTECTED] wrote:
It's not really possible to do that. The blogger might've thought he'd
accomplished something but I seriously doubt that his database was
consistent afterward. You can go back in time using PITR, if you had
the foresight and resources to set
Reece Hart [EMAIL PROTECTED] writes:
However, it's not clear that you've considered a clause like 'ORDER BY
(foo IS NULL), foo', which I believe is not implementation dependent.
Yeah, that should work reasonably portably ... where portable means
equally lousy performance in every
Does anyone know how to adjust the IPC settings in Windows?
If I wanted to increase shared_buffers settings, in linux I would simply
adjust the SHMMAX and SHMMIN settings, following the docs
(http://www.postgresql.org/docs/8.2/static/kernel-resources.html#SYSVIPC).
In Windows, ?
Cheers,
Ivan Voras [EMAIL PROTECTED] writes:
Ok, just to verify I'm thinking about it in the right way: in
abstract, with PITR, I would need a known-good starting point (e.g. a
full backup) + files from pg_xlog created from the time of the
starting-point, then restore the starting-point backup and
Kevin Neufeld [EMAIL PROTECTED] writes:
Does anyone know how to adjust the IPC settings in Windows?
There aren't any such settings in Windows, AFAIK. There's certainly
not anything directly corresponding to SHMMAX, say. What have you
run into that makes you think you need to adjust something?
What can I expect for a date format from a PGresult containing binary
results? Specifically the Oid type is TIMESTAMPTZOID. In this case
what does the PQgetvalue actually return? What does the char* point to?
Thanks.
- samantha
Andrej Ricnik-Bay wrote:
On 11/8/07, Collin Kidder [EMAIL PROTECTED] wrote:
I'm with Thomas. I think that, while inline posting is a good thing,
bottom posting is dead stupid and wastes my time.
Just as bad as top-posting, really.
It is far easier to
follow a thread with top posting
Does anyone know how to adjust the IPC settings in Windows?
There aren't any such settings in Windows, AFAIK.
Correct. The only real adjustable limit is the size of the Windows pagefile,
but that one is normally dynamic. But there must be room for all the shared
memory in it. It's not
94 matches
Mail list logo