I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make,
please let me know.
Kind regards,
Christiaan Willemsen
Christiaan Willemsen wrote:
Yes, it is a 64 bit machine, I'm sure of that:
file
Hi.
I use latest version of Postgre in windows XP
I try to restore a database from .tar backup,into a new database.Using EMS
Manager
it works fine,my database is creating and restoring succesfully.
My application creates a .bat file and run it,restore is unsuccesfully
but file is :
@echo off
Mr. John wrote:
but on the server is no database called _struct_fis_
err_resto.txt file contents only 0.
If I add -d
@echo off
pg_restore.exe -h 192.168.1.1 -p 5432 -U postgres -d _struct_fis_ -C -v
stru.tar 2log_resto.txt
echo %errorlevel% err_resto.txt
error is 1 and log
Garry Saddington wrote:
Is there a way to make the following statement return the total of all
effort. At the moment it gives a list of sum vs case.
select sum(effort),
CASE WHEN effortandattainment.effort=5 THEN -3
WHEN effortandattainment.effort=4 THEN -2
WHEN
tanks for reply.
Why should I connect to a existing database to restore another one ?
from documentation,pg_restore seems to can do this :
http://www.postgresql.org/docs/8.0/interactive/app-pgrestore.html
-C
--create
Create the database before restoring into it. (When this option is
On Sun, Nov 16, 2008 at 12:39 PM, Peter Billen [EMAIL PROTECTED] wrote:
Hi all,
Is the instruction 'ALTER TABLE x ENABLE/DISABLE TRIGGER y' part of the
current transaction? That is, say that there are two ongoing transactions,
T1 and T2. Is the trigger y still enabled in transaction T2 if
Mr. John wrote:
tanks for reply.
Why should I connect to a existing database to restore another one ?
How do you issue a CREATE DATABASE command without being connected to
something?
from documentation,pg_restore seems to can do this :
On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen [EMAIL PROTECTED] wrote:
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make,
Yes, I did ;)
Isak Hansen wrote:
On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen [EMAIL PROTECTED] wrote:
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any
thanks for answer Richard
I'm new with Postgre,my version is 8.3
I read pg_restore documentation and what I understood is that using
pg_restore.exe with -C will create the database named in backup archive or
specified with -d
How exactly do I have to run pg_restore to create my database and
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make,
please let me know.
Did you already try changing shmall as Martijn
On 17/11/2008 11:26, Mr. John wrote:
I read pg_restore documentation and what I understood is that using
pg_restore.exe with -C will create the database named in backup archive
or specified with -d
You have to connect to *some* database, as Postgres doesn't have the
concept of just
Hi,
I am running multiple 8.2 databases on a not-so-powerful W2K3 server -
and it runs great - for the majority of time. However I have some
monster tsearch queries which take a lot of processing and hog system
resources - especially disk.
I am not concerned with the amount of time or speed
Thanks Raymond
pg_restore.exe -h 192.168.1.1 -p 5432 -U postgres -d postgres -C
stru.tar 2log_resto.txt
echo %errorlevel% err_resto.txt
created and restored my database with the name saved in backup
Thanks a lot.
From: Raymond O'Donnell [EMAIL
On Mon, Nov 17, 2008 at 1:15 PM, Howard Cole [EMAIL PROTECTED] wrote:
Hi,
I am running multiple 8.2 databases on a not-so-powerful W2K3 server - and
it runs great - for the majority of time. However I have some monster
tsearch queries which take a lot of processing and hog system resources -
On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
Yes, I did ;)
Still the same error, i.e. unable to allocate shared memory? What does
sysctl -a | grep shm say?
Isak
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 68719476736
Isak Hansen wrote:
On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks. Non
standard parts of my postgresql.conf are as follows:
max_connections=100
shared_buffers=128MB
work_mem=4MB
maintenance_work_mem=256MB
max_fsm_pages=204800
max_fsm_relations=1500
Any tips appreciated.
Pls, show
1)
[EMAIL PROTECTED] wrote:
Quoting Richard Huxton [EMAIL PROTECTED]:
But I'm guessing that's not what you mean. Can you show what output
you'd like to have?
effort sum
1 245
2 463
etc.
Each value for effort has a different statistical meaning as in the case
statement.
Sorry -
Steve Atkins wrote:
On Nov 16, 2008, at 2:41 AM, Michelle Konzack wrote:
Am 2008-11-15 09:53:15, schrieb Scott Marlowe:
What's mess up is that the solution given the user DOES work. She
just refuses to try it, because she assumes that the mailing list
server doesn't see the exact same CC
I create a db wiht user postgres, but other users can't no create
tables, and I give all privileges.
(banco is my db)
grant all on database banco to public;
grant create on database banco to public;
This is the error:
*ERROR: must be owner of relation (table)*
Help me!!!
--
Sent via
On Mon, Nov 17, 2008 at 6:46 AM, charlie derr [EMAIL PROTECTED] wrote:
Steve Atkins wrote:
On Nov 16, 2008, at 2:41 AM, Michelle Konzack wrote:
Am 2008-11-15 09:53:15, schrieb Scott Marlowe:
What's mess up is that the solution given the user DOES work. She
just refuses to try it, because
result for your query
cliente_fone 341130 3345 26760k
De: Craig Ringer [EMAIL PROTECTED]
Para: paulo matadr [EMAIL PROTECTED]
Cc: GENERAL pgsql-general@postgresql.org
Enviadas: Sábado, 15 de Novembro de 2008 5:53:12
Assunto: Re: Res: [GENERAL] Archive files
Serge:
OS linux, my distro is debian
I don't changes in the configuration
Instalation:
Download tar file
unzip
cd /pghead
./configure
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su postgres
/usr/local/pgsql/bin/initdb -D
From: Gustavo Rosso [EMAIL PROTECTED]
Subject: [GENERAL] ERROR
To: pgsql-general@postgresql.org
Date: Monday, November 17, 2008, 3:08 PM
I create a db wiht user postgres, but other users can't
no create tables, and I give all privileges.
(banco is my db)
grant all on database banco to
Teodor Sigaev wrote:
The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks.
Non standard parts of my postgresql.conf are as follows:
max_connections=100
shared_buffers=128MB
work_mem=4MB
maintenance_work_mem=256MB
max_fsm_pages=204800
max_fsm_relations=1500
Any tips appreciated.
On Mon, Nov 17, 2008 at 8:17 AM, Howard Cole [EMAIL PROTECTED] wrote:
Teodor Sigaev wrote:
The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks. Non
Your entire disk io subsystem is a pair of hard drives. I'm assuming
software RAID.
The time that this query takes is not the
Scott Marlowe wrote:
Your entire disk io subsystem is a pair of hard drives. I'm assuming
software RAID.
Correct.
The time that this query takes is not the issue, rather it is the impact
that it has on the server - effectively killing it for the 40 seconds due to
the heavy disk access.
On Mon, Nov 17, 2008 at 8:42 AM, Howard Cole [EMAIL PROTECTED] wrote:
Scott Marlowe wrote:
Your entire disk io subsystem is a pair of hard drives. I'm assuming
software RAID.
Correct.
The time that this query takes is not the issue, rather it is the impact
that it has on the server -
Scott Marlowe wrote:
The problem is most likely you're I/O bound. If one query is hitting
a table it can pull in data (sequentially) at 40 to 80 megabytes per
second. Since most of your queries are small, they don't run into
each other a lot, so to speak. As soon as your big reporting query
On Mon, Nov 17, 2008 at 9:36 AM, Howard Cole [EMAIL PROTECTED] wrote:
Scott Marlowe wrote:
The problem is most likely you're I/O bound. If one query is hitting
a table it can pull in data (sequentially) at 40 to 80 megabytes per
second. Since most of your queries are small, they don't run
Scott Marlowe wrote:
Best of luck on this.
Thanks Scott.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am using Postgresql to store all my research related data. At the
moment I am just finishing my PhD thesis and I want to cite postgresql
correctly but can't find how to do it. Could somebody give me an advice?
Many thanks
tomas
--
Sent via pgsql-general mailing list
Hi the list,
I have a performance problem and would like to any input on how to make it
perform as desired. In the DB, there are a few tables over 3 million records
in postgis. When I do some operation on the tables, e.g. CREATE INDEX, it
takes hours without results. I believe there must be
Hi,
I am trying to compile my own copy of libpq.dll using bcc32.exe, the
docs say it is possible, but I get a error when it tries to compile dirent.c
Has anyone been able to do this?
C:\postgresql-8.3.5\src\interfaces\libpqmake -N -DCFG=Release /f bcc32.mak
MAKE Version 5.3 Copyright (c)
On Mon, Nov 17, 2008 at 11:21 AM, John Zhang [EMAIL PROTECTED] wrote:
Hi the list,
I have a performance problem and would like to any input on how to make it
perform as desired. In the DB, there are a few tables over 3 million records
in postgis. When I do some operation on the tables, e.g.
On Mon, Nov 17, 2008 at 11:09 AM, Tomas Lanczos [EMAIL PROTECTED] wrote:
I am using Postgresql to store all my research related data. At the moment I
am just finishing my PhD thesis and I want to cite postgresql correctly but
can't find how to do it. Could somebody give me an advice?
You can
On Mon, 17 Nov 2008, Scott Marlowe wrote:
On Mon, Nov 17, 2008 at 11:21 AM, John Zhang [EMAIL PROTECTED] wrote:
Hi the list,
I have a performance problem and would like to any input on how to make it
perform as desired. In the DB, there are a few tables over 3 million records
in postgis.
Hello,
I guess most of you guys heard about In Memory Database.I have a small
question regarding it.I need to create an In Memory Database for
postgresql through which I have to perform various operations on
postgresql database(queries,procedures,programs using pqxx API
etc...).I
2008/11/18 aravind chandu [EMAIL PROTECTED]:
Hello,
Hi!
I guess most of you guys heard about In Memory Database.I have
a small question regarding it.I need to create an In Memory Database for
postgresql through which I have to perform various operations on postgresql
Hi,
I have a problem to find as fast as possible files that are double or
in other words, identical.
Also identifying those files that are not identical.
My approach was to use dir /s and an awk script to convert it to a sql
script to be imported into a table.
That done, I could start issuing
Hi,
Trying to get a libpq.dll that only has SSL deps using these instructions:
http://www.postgresql.org/docs/8.3/interactive/install-win32-libpq.html
It compiles a bit then dies at:
C:\postgresql-8.3.5\src\interfaces\libpqnmake /f win32.mak
Microsoft (R) Program Maintenance Utility Version
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: Monday, November 17, 2008 12:06 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but need
help
Hi,
Trying to get a
On Mon, Nov 17, 2008 at 12:11 PM, aravind chandu [EMAIL PROTECTED] wrote:
Hello,
I guess most of you guys heard about In Memory Database.I have
a small question regarding it.I need to create an In Memory Database for
postgresql through which I have to perform various operations
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of aravind chandu
Sent: Monday, November 17, 2008 11:11 AM
To: postgresql Forums
Subject: [GENERAL] In memory Database for postgres
Hello,
I guess most of you guys heard about In Memory Database.I
have a small question
Dann Corbit wrote:
How much disk space do you have?
I guess that you are running out of space.
During the link, watch the available disk space.
Hi Dan,
Thanks for the reply :-)
I actually got it working.Now the only problem is it still has a
dependency for
MSVCR90.DLL
Does
On Mon, Nov 17, 2008 at 8:43 PM, Tony Caduto
[EMAIL PROTECTED] wrote:
Does anyone know if this can be done with mingw so I can eliminate the
MSVCR90.DLL dependency?
I have it installed but that is even more foreign to me than VS :-) (mostly
use borland CodeGear tools)
That's the easiest way
-Original Message-
From: Tony Caduto [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2008 12:44 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Trying Compile libpq.dll with VC++ 9.0, but
need
help
Dann Corbit wrote:
How much disk space do
I meant something for use in publications, like it is used for R and
almost identically for GRASS:
R Development Core Team (2008). R: A language and environment for
statistical computing. R Foundation for Statistical Computing,
Vienna, Austria. ISBN 3-900051-07-0, URL
Dann Corbit wrote:
Change from /MD to /MT and it will not use the runtime DLL.
Look under: Properties - Configuration Properties - C/C++ - Code
Generation - Runtime Library
Hi Dann,
I changed that in the win32.mak file and now it gives this error:
link.exe
On Mon, Nov 17, 2008 at 11:36 AM, Jeff Frost
[EMAIL PROTECTED] wrote:
On Mon, 17 Nov 2008, Scott Marlowe wrote:
On Mon, Nov 17, 2008 at 11:21 AM, John Zhang [EMAIL PROTECTED]
wrote:
Hi the list,
I have a performance problem and would like to any input on how to make
it
perform as
In my opinion very nice solution is building part of PostgreSQL
database in memory - below it is instruction how to build PostgreSQL
schema in memory in Linux. I tested this with my ROLAP solution for
recalculation MOLAP cubes in memory and then join with master cube
(this speeds up proces about
I'm joing to Tomas - and I want to cite postgresql too in my PhD thesis.
Regards,
Blazej Oleszkiewicz
2008/11/17 Tomas Lanczos [EMAIL PROTECTED]:
I meant something for use in publications, like it is used for R and almost
identically for GRASS:
R Development Core Team (2008). R: A
Sorry I forgot about create tablespace script - this is the SQL script:
CREATE TABLESPACE ram_space LOCATION '/mnt/ram0/pgspace';
And then:
CREATE TABLE (...) TABLESPACE ram_space;
and table is in memory.
Regards,
Blazej
2008/11/17 Blazej [EMAIL PROTECTED]:
In my opinion very nice solution
On Mon, Nov 17, 2008 at 3:02 PM, Blazej [EMAIL PROTECTED] wrote:
In my opinion very nice solution is building part of PostgreSQL
database in memory - below it is instruction how to build PostgreSQL
schema in memory in Linux. I tested this with my ROLAP solution for
recalculation MOLAP cubes in
On Mon, 17 Nov 2008, Scott Marlowe wrote:
Just wondering if you compared it to how fast it runs if you've got
lots of shared_buffers and everything fits into memory. That would be
an interesting comparison.
With a large increase in work_mem as well to speed up sorting. If the
bottleneck is
2008/11/18 Scott Marlowe [EMAIL PROTECTED]:
On Mon, Nov 17, 2008 at 3:02 PM, Blazej [EMAIL PROTECTED] wrote:
In my opinion very nice solution is building part of PostgreSQL
database in memory - below it is instruction how to build PostgreSQL
schema in memory in Linux. I tested this with my
paulo matadr wrote:
result for your query
cliente_fone 341130 3345 26760k
OK. And what about indexes, logging triggers, etc?
Can you post the output of:
\d client_fone
from psql?
(I can't really imagine how indexes alone could generate that much
logging data, though).
--
Craig
Hi,
I have experimented with PostgreSQL's table locking and FOR UPDATE
capabilities. But what I'm looking for is a row level lock specific to
only a set of rows, not the entire table.
For example, there is a table with many rows. Threads are doing
SELECTS to read some rows. They should be
Darren Govoni [EMAIL PROTECTED] writes:
For example, there is a table with many rows. Threads are doing
SELECTS to read some rows. They should be allowed to get results on
rows that are not currently locked by another thread's SELECT,FOR UPDATE
or equivalent read lock for those rows only.
Hi.
It is very strange
I checked that it was ready in VC9 again.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_LIBPQ_WIN32MAK.txt
Furthermore, even psql was checked.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/psql_win32_pg83.mak
Please move psql_win32_pg83 win32.mak on
Thank you for the suggestion.
It seems that still blocks. Here is what I'm trying to achieve.
I have 10 rows each with an id 1,2,3,4 etc.
In one thread I want to update rows with id 4 (1-3) in my_table
inside a transaction (i.e. begin work; update where; commit work;)
In another thread I do
On Monday 17 November 2008 17:02:54 Blazej wrote:
Of course you must delete schema before shutdown PostgreSQL and OS - I
dont't now how resolve problem with error when the schema was not
deleted? - I have no time to think about it maybe anybody know how to
restore db when the in memory schema
Hiroshi Saito wrote:
Hi.
It is very strange
I checked that it was ready in VC9 again.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_LIBPQ_WIN32MAK.txt
Furthermore, even psql was checked.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/psql_win32_pg83.mak
Please move psql_win32_pg83
On Mon, Nov 17, 2008 at 7:13 PM, Robert Treat
[EMAIL PROTECTED] wrote:
On Monday 17 November 2008 17:02:54 Blazej wrote:
Of course you must delete schema before shutdown PostgreSQL and OS - I
dont't now how resolve problem with error when the schema was not
deleted? - I have no time to think
Hi Ho!
--- On Tue, 11/18/08, Lothar Behrens [EMAIL PROTECTED] wrote:
Hi,
I have a problem to find as fast as possible files that are
double or
in other words, identical.
Also identifying those files that are not identical.
My approach was to use dir /s and an awk script to convert
it
Hi all,
(Version 3.5.5)
I have tried to figure this out, but the docs, google, and my all
imagination fail me. I want to use a join clause with a using list
in an update statement. The following works, but it uses the WHERE
version of a join:
update new_pivoted_table a set 2008-11-10 =
Gustavo Rosso wrote:
I create a db wiht user postgres, but other users can't no create
tables, and I give all privileges.
(banco is my db)
grant all on database banco to public;
grant create on database banco to public;
This is the error:
*ERROR: must be owner of relation (table)*
Howard Cole wrote:
If I reduce maintenance_work_mem
then the database dump/restore is slower but there is less overall
impact on the server.
There could be more impact, rather than less, if it forces a sort that'd
be done in memory out to disk instead. If you have dedicated storage on
Howard Cole wrote:
Thanks for the input Scott. You are correct - I am IO bound, but only
for the query described. 99% of the time, my IO runs at 3% or less, even
during peak times, only this one query, which happens approximately 10
times a day grinds the system to a halt.
If your I/O is
On Thu, 13 Nov 2008, Scott Marlowe wrote:
On Thu, Nov 13, 2008 at 1:09 PM, David Wilson [EMAIL PROTECTED] wrote:
On Thu, Nov 13, 2008 at 2:03 PM, [EMAIL PROTECTED] wrote:
I have several tables that when I run VACUUM FULL on, they are under 200k,
but after a day of records getting added
On Mon, Nov 17, 2008 at 11:10 PM, Craig Ringer
[EMAIL PROTECTED] wrote:
I also think it's a wee bit of a pity that there's no way to tell Pg
that a job isn't important, so data shouldn't be permitted to push much
else out of shared_buffers or the OS's cache. The latter can be ensured
to an
Scott Marlowe wrote:
On Mon, Nov 17, 2008 at 11:10 PM, Craig Ringer
[EMAIL PROTECTED] wrote:
I also think it's a wee bit of a pity that there's no way to tell Pg
that a job isn't important, so data shouldn't be permitted to push much
else out of shared_buffers or the OS's cache. The latter
Finally got everything to compile with MinGW. Thanks to everyone that
helped me out getting it going.
Here are the download links:
Libpq.dll 8.3.5.8322 with SSL No Zlib (includes the latest openssl dlls
0.9.8i also built with MinGW)
http://www.milwaukeesoft.com/libpq_mingw_ssl.zip
If you
Lothar Behrens wrote:
But how to query for files to display a 'left / right view' for each
file that is on multible places ?
One approach is to use a query to extract the names of all files with
duplicates, and store the results in a TEMPORARY table with a UNIQUE
index (or PRIMARY KEY) on the
hi All,
I am using PostgreSQL 8.2, and I am interested in creating a table B that
inherits table A, but with all it's data!
create table B {a int} inherits A, just adds the structure of table A, not its
data.
Is it possible to do this without the classic way - trigger on table A so each
76 matches
Mail list logo