Hello !
I was just wondering if anyone knows if this is a bug or whats up.
Im using psql 7.2.2
I can do full restores and dumps all day long, however when I do the
following I run into problems
Do a full dump with pg_dump -Fc -O Database1 > dump.tar
I restore one table to Database1 using
pg
Hello,
Sorry for this newbish question.
Briefly, my problem:
--
I expect the database I'm working on to reach something in the order of
12-16 Gigabytes, and I am interested in understanding as much as I can about
how I can make this go as fast as possible on a linux system. I have
hi,
I am looking for some examples/text
for implementing full text index in postgresql. Can anyone help me in this
regard?
Thanks.
Hi all,
I am running windows xp and went through the setup
instructions according to the instructions.
When I attempt to run the command:
ipc-daemon2
I get the following message:
“This application has failed to start because
cygpopt-0.dll was not found. Re-installing t
Hello!
I have a Problem.
A table with a ForeignKeyRef exits. The Name of the field with this FK-Constraint is
'id_employee'
because it is referencing the field 'id_employee' in 'public.sd_employee'. I drop this
column of the
table with cascade in a script:
ALTER TABLE public.sd_messaging_parti
Najib Abi Fadel wrote:
Hi, i am using PostgreSQL 7.3.2
there's a bug for the date '2005-03-27' !!!
For other dates the function works well !!
I have 7.4.2 and it works well:
[EMAIL PROTECTED]:~$ psql template1
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type:
Subject: Re: [GENERAL] Bug in function to_char() !!
Message-Id: <[EMAIL PROTECTED]>
From: [EMAIL PROTECTED]
Date: Thu, 01 Jul 2004 13:47:04 +0100
Hi
Try
SELECT to_char('2005-03-27'::date,'/MM/DD');
I think you date format is wrong
Simon
Original Message
From: Najib
On Wed, 30 Jun 2004 22:32:26 -0500, [EMAIL PROTECTED] (Bruno Wolff III)
wrote:
>On Wed, Jun 30, 2004 at 18:23:08 -0500,
> [EMAIL PROTECTED] wrote:
>>
>> What do other sites with mondo databases do?
>
>There have been comments from people using storage systems that they
>can freeze the storage sy
If I bought one of these boxes/OS combos as a postgresql database server,
would postgresql be able to make the best use of it with a huge (e.g. 40GB)
database?
Box: HP ProLiant DL585, with 4 AMD64 CPUs and 64GB of RAM. (other
vendor options also exist)
OS: SUSE enterprise 8 linux for AMD
Thanks all in providing me some needed tips and information. Being a newbie
to this environment, I was jumping from one set of README's from a previous
versions and the reading the current README's for 7.4.3 and was confused on
why one set of instructions was using the ipc-daemon2 and the current
On Thu, 2004-07-01 at 11:45, [EMAIL PROTECTED] wrote:
> If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I
> increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE
> relcaim all overlooked pages or must I do a VACUUM FULL?
Let's say you have a table w
On Wed, 30 Jun 2004 18:23:08 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> What do other sites with mondo databases do?
>
Let me offer the ideas of what I've used in some high-end environments
before. First, we've always used a mirror configuration in most
situations, simply for reliabil
Is there any way to grant user access at the row level? Or maybe some
way to simulate it?
Alex
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> Soeren Gerlach <[EMAIL PROTECTED]> writes:
> > * pg_dump takes 2/3 of the [single] CPU, postmaster the other 1/3 for
> > both dumps
>
> Really!? Hmm, that seems fairly backwards ... thinks ...
>
> In the -Fc case this makes some amount of sense because pg_dump runs
> gzip-style compression on
Hello,
How PostgreSQL keeps its data?
When I enter a data dir I notice a bunch of files while I have a
single database with the only table.
Is there a reference on the inner format and structure of
PostgreSQL 7.3 ?
--
Best regards,
Ilia mailto:[EMAIL PROTECTED]
Juan Jose Costello Levien <[EMAIL PROTECTED]> writes:
> Hello,
> I am trying to use a trigger function I wrote in C. Basically what I
> want to do is to audit a table when a row is inserted into another
> table by copying the row to the new table. It compiles Ok and I
> created a shared library tr
If you increase max_fsm_pages to a large enough number then the next
vacuum analyze will make all the pages with free space available to be
reused. A normal VACUUM does not actually reclaim space (unless it's at
the end of the table I think), it only marks the space as reuseable.
VACUUM FULL w
Hello,
I am trying to use a trigger function I wrote in C. Basically what I
want to do is to audit a table when a row is inserted into another table
by copying the row to the new table. It compiles Ok and I created a
shared library trigger.so. But when I load it into pgAdmin it tells me
'An err
does anybody know what has happened to www.postgresql.org I am getting page
not found, although I can ping it?
where can i find the latest version of postgresql and it utilities/tools?
Any news on the windows version? I am probably going to use a Linux version
in production, but having windows ve
Title: Extract data from MySQL database using PostgreSQL
Hi
I am very new to PostgreSQL.
Does PostgreSQL support to extract records from tables built in MySQL database?
Thanks,
Wen
If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I
increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE
relcaim all overlooked pages or must I do a VACUUM FULL?
Wes
---(end of broadcast)---
TIP 9: th
Hello,
I have a technical question about VACUUM
I assume all table data is kept in a single file
and each index has its single file also.
Also I assume that VACUUM cleans the file of 'dead pages' that consist
of dead rows only.
How does it manage to reduce file size without any locks ?
Or which
Christopher Cashell <[EMAIL PROTECTED]> writes:
> [2004-06-30 08:44:53 AM] Failed connection to database template1
> with error: FATAL: the database system is starting up
> .
> [2004-06-30 08:44:53 AM] Failed connection to database template1
> with error: FATAL: the
23 matches
Mail list logo
