I would like to know whether I can set DBmirror replication from the fedora core
5_64 which postgresql8.1 was installed by rpm process not by compiling the
source. All of the component include server, contrib, perl, test, doc, devel
and lib were also rpm and what is the way to set it?
Do I need to
Sandy,
SELECT typowner from pg_type where typname='trigger';
check if typeowner exists in the column usesysid of pg_user
by doing
SELECT * from pg_user ;
if typeowner does not exists there is a problem.
regds
On 12/21/06, Sandy Spence <[EMAIL PROTECTED]> wrote:
Hi All,
I get the followin
Arnau a écrit :
Hi all,
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long, so I need your ad
There is an encoding which is used inside the server. Then the client can
specify what encoding the strings are he is sending. The server then
transforms the clientencoding to the internal representation. When the
described problem occurs this means that something in this process is not set
or
Thanks for the feed back. Doubling the work_men from 10240 to 20480
seemed to make the process faster but then I ran out of disk space.
Shared buffers are at 2000 which I can try increasing.
I now need to move the database off the system partition to my working
partition which has more space. I
On Thu, 21 Dec 2006, Arnau wrote:
And as result I got a file of 2.2GB. The improvement has been quite big but
still very far from the 10-15 minutes that Jeff says or the Thomas'3 minutes.
Just FYI, if you were reporting the DB size by the size of the compressed dump
file, then that's not exa
Hi all,
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long, so I need your advice about
how yo
I'm using Linux server with postgres 8.0.2 and windows clients with VB
aplications that using pgOleDB.dll and Libpq.dll.
The problem is:
Some user updates a record (with Text type field) with '?' character in this
field
Then, when someone select this record the '?' characters appears like '$1'
Hi All,
I get the following error when performing a pg_dump
dumping database "ltt"...
pg_dump: WARNING: owner of data type trigger appears to be invalid
the owner and database exists, I have run the following select statement,
select pg_class.oid, pg_trigger.tgrelid from pg_trigger left join p
