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 ../bin/post
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" 2>>log_resto.txt
> echo %errorlevel% >err_resto.txt
>
>
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 effortandattainm
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
use
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
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 :
> http://www.postgresql.org/docs/8.0/interactive/a
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
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 a
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 t
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 Martij
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 connec
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" 2>>log_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 resour
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 y
#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) effectiv
[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
> state
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 lis
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 pgsql-ge
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 refu
result for your query
"cliente_fone" 341130 3345 26760k
De: Craig Ringer <[EMAIL PROTECTED]>
Para: paulo matadr <[EMAIL PROTECTED]>
Cc: GENERAL
Enviadas: Sábado, 15 de Novembro de 2008 5:53:12
Assunto: Re: Res: [GENERAL] Archive files growth!!!
paulo matadr wro
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 /usr/local
> 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 databas
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
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
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
hit
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 d
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 (pgsql-general@postgresq
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 someth
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\libpq>make -N -DCFG=Release /f bcc32.mak
MAKE Version 5.3 Copyright (c) 19
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 tabl
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 c
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. W
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
> data
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 que
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\libpq>nmake /f win32.mak
Microsoft (R) Program Maintenance Utility Version 9
> -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
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 opera
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 r
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 anyon
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 easies
> -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 di
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 http://www.R-project
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 @C:\DOCUME~1\20659\L
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 mak
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 10
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 l
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 solutio
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 cub
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 w
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 allo
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 onl
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 src\bin\ps
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 sche
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 w
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
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 con
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" = b.da
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 (t
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
separ
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 getti
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
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. T
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 n
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
inse
76 matches
Mail list logo
