I have the following table in a win32 8.2.2 database: (dumped from pgadmin)
CREATE TABLE email_directory
(
email_directory_id serial NOT NULL,
mailbox_id integer NOT NULL,
path character varying(255) NOT NULL,
marked_for_deletion boolean NOT NULL DEFAULT false,
CONSTRAINT email_directory_pke
:
taskkill /f /pid 1234
This appeared to kill the session, but postgres still thinks the session
is live with the same process id.
Using the SysInternals process explorer - there doesn't appear to be a
process with the given ID.
How can I get postgres to drop this session?
Thanks
Howard
Hi,
I've written about this problem before and thanks to Bill Bartlett and
Richard Huxton for previous replies, but the problem keeps coming up...
I'm running postgresql V8.2.5 (I think!) on W2K3 Server and occasionally
I want to rebuild a database. However I cannot drop the database because
(now
redundant for 4 days) and the mysterious connection is still there.
There has to be a better solution?
Howard.
Howard Cole wrote:
Hi,
I've written about this problem before and thanks to Bill Bartlett and
Richard Huxton for previous replies, but the problem keeps coming up...
I'
Dann Corbit wrote:
What happens if you disable the net card on your server machine?
Hi Dann,
The connection is from IIS worker process running on the same machine.
My problem is that I want to disable connections for a single database.
Disabling the pgsql service or disabling the card (can
Thomas H. wrote:
On Tue, Dec 11, 2007 at 05:50:46PM -0500, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Howard Cole wrote:
I take it from the lack of response that nobody knows how to kill
a connection from the postgresql side on windows?
You can't, short of sendi
Which you can do, no? I thought pg_ctl's kill option was invented
specifically to make this less painful on Windows.
I shall look into the pg_ctl options to see if the kill option does
what taskill cannot (thanks for the heads up on that)
Using
$ pg_ctl kill TERM [pid]
worked great. Since v
Thomas H. wrote:
wasn't the OP asking for a way to kill active connections to a db?
afaik pgAdmin3 does provide this functionality:
pgadmin3 > tools > server status
there you can easily terminate connections & transactions to a
particular db. works pretty well in my test, i can kill active
c
Bruce Momjian wrote:
Alvaro Herrera wrote:
Bruce Momjian wrote:
Alvaro Herrera wrote:
Huh, why is it awkward?
Alternatively, you can send the signal directly using kill
(or pg_ctl kill TERM [process id]).
I think we should mention Windows in there somewhere, b
Hi all,
I don't understand the last result:
select 'Ho Ho Ho' ~* '^Ho'; returns true
select 'Ho Ho Ho' ~* ' Ho'; returns true
select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is a
space between ^ and ])
From my limited experience of regex, the last one is searching for either
Richard Huxton wrote:
Howard Cole wrote:
Hi all,
I don't understand the last result:
select 'Ho Ho Ho' ~* '^Ho'; returns true
select 'Ho Ho Ho' ~* ' Ho'; returns true
select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note th
Florian, Richard, Ivan.
Fantastic response thank you very much.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Martijn van Oosterhout wrote:
On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote:
am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole folgendes:
Your expression works fine Richard, as does '(^| )ho', but can you tell
me why '[ ^]ho' doesn't
Howard Cole wrote:
Martijn van Oosterhout wrote:
On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote:
am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole
folgendes:
Your expression works fine Richard, as does '(^| )ho', but can you
tell me why '[ ^]h
!!!
;)
I am trying to match the beginning of a name, so to search for
'how' in 'Howard Cole' should match
'col' in 'Howard Cole' should match
'ole' in 'Howard Cole' should NOT match,
So using ~* '(^| )col' works for me! As wou
Hi,
a puzzle to solve...
I have a table with a primary key, and a timestamp, e.g.
idstamp
1 2011-02-01 10:00
2 2011-02-01 09:00
3 2011-02-01 11:00
Now for reasons too painful to go into, I need to reorder the id
(sequence) so that they are in time order:
idstamp
1 20
On 22/02/2011 5:18 PM, Vibhor Kumar wrote:
If you are using PG 8.4 then you can try something with row_number as
given below:
select id,stamp, row_number() over(order by stamp) from test;
Or
Create table test1 as select row_number() over(order by stamp) as id, stamp
from test;
Thanks& Reg
On 04/04/2011 11:47 AM, salah jubeh wrote:
What will happen if
1. dropped table a
2. insert data on b and the other relations
3. restore table a and it's dependency (table b).
Simple advice would be to create a script on an offline system for
testing - when you are happy with the results - do
objects?
Thanks,
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
configuration variable lo_compat_privileges when I work out how to use
it. For the longer term, could I borrow your script for the DO :)
I dont seem to have it anymore... but here is a re-created, untested
version.
do $$
delcare r record;
begin
for r in select loid from pg_catalog.pg_large
I've just installed Postgres 8.2.7 on a W2K3 machine, and created the
data directory post installation using initdb.
Everything appears to be working fine, but there are no log files
created. Nor is there a pg_log subdirectory.
I have made no changes to the postgresql.conf file. What am I missin
I think I've solved this one - the compared the old to the new
postgresql.conf; the new version did not redirect the standard output.
Thanks.
Howard Cole wrote:
I've just installed Postgres 8.2.7 on a W2K3 machine, and created the
data directory post installation using initdb.
I run several databases on a windows server all using the same cluster.
Each database is backed up separately using pg_dump - but the size of
the databases is leading me to think that the WAL backup strategy will
reduce my backup bandwidth. The flaw in this is that the WAL backup is
not confine
Can anyone give me a hint how to trace the cause of this error message
in the error log:
ERROR could not open relation 1663/20146/128342: Permission Denied
Running 8.2.7 on W2K3.
Thanks.
Howard Cole.
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Full Control".
Howard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Howard Cole wrote:
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Full Control".
Howard
Further, the system works fine normally. The permissions error
Adrian Klaver wrote:
On Friday 23 May 2008 6:02 am, Howard Cole wrote:
Howard Cole wrote:
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Fu
Hello All,
Apologies if this is a bit off-topic. Any hints as to what character
sequences need escaping in Postgres's regular expressions?
Let me show you the problem.
If I want to find all strings that start with 'postgres' I use the regex
select str ~ '^postgres'.
However if str contains
though I do not store my password in pgadmin.
This only seems to have become a problem since installing 8.4 and
associated version of pgadmin.
Is this the desired behaviour or is it a bug?
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Raymond O'Donnell wrote:
On 16/09/2009 10:55, Howard Cole wrote:
Hi All,
I have been having a few problems with my password file recently,
causing my scheduled pg_dump to fail. The problem is that the
pgpass.conf file keeps changing. Eventually I narrowed it down to using
pgadmin.
Richard Huxton wrote:
Raymond O'Donnell wrote:
On 18/09/2009 16:07, Howard Cole wrote:
Thanks for the update. Unfortunately this behaviour has the side effect
of deleting passwords that I have set up in the file manually for other
applications (namely the backup), which runs unde
Hi everyone,
Is data compressed when stored in a database table/field?
If not, is there an easy way (invisible to the database client) to
compress text and bytea data without actually using compressed disks?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-gene
A. Kretschmer wrote:
http://www.postgresql.org/docs/current/static/storage-toast.html
Andreas
Thanks Andreas.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 13/07/2011 8:49 AM, Giuseppe Sacco wrote:
Hi all,
I moved a few clusters from 8.4 to 9.0 since I required the new way of
authenticating against LDAP (or, in my case, AD). Now, I found the new
database version introduced permissions on large object, so my
application, in order to share large ob
option to use the compatibility option and then, when you have
updated your code, you can turn off the compatibility mode and run your
script once.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
build and then dumping
that database to restore in an 8.4.3 database, or just dump the existing
8.2.4 database and restore in 8.4.3?
Thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
e was seamless.
Many thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a query?
Thanks.
Howard Cole.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
As part of my log configuration, I log statements that take over 3
seconds. I find this very useful for optimising tables etc. The problem
is that it produces verbatim some very large statements which can create
huge log entries, which are probably responsible themselves for slowing
the system
Appologies if this has already been fixed, but I have come across a
problem with pg_dump when dumping a single non-public schema. (This is
on Windows Pg 8.2). It did not cause any major problems because I
obviously made a backup of the database before I tried a restore, and
managed to fix the b
Hello all,
Does postgres 8.3.* work on Windows w2k8 x64? I could not find any
reference to this on the website.
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I think it does. It certaily works on w2k3 x64 and it should work on w2k8
on x86. I haven't heard a specific report about it working on w2k8 x64, but
since I have heard no report that it *doesn't* work, I think you can safely
assume that it works :-)
Thanks Magnus, Dave. On those assertive co
Reuven M. Lerner wrote:
I'm running a medium-traffic Web site that has been running for a few
years, and which uses about four PostgreSQL databases on a regular
basis. I'm currently running 8.2, although I'm planning to upgrade to
8.3 in the coming week or two, in part because of the problems
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
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.
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.
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
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
dn't seem to speed up. Perhaps there
is something wrong with these databases? The explain analyse seems to
come back with identical plans on these. Any ideas? (p.s. I am running
autovacuum)
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Craig Ringer wrote:
Howard Cole wrote:
Unfortunately I am on a windows platform. Plus I am running windows
software raid so there is little tweaking allowed.
Don't write the possibility off too quickly. The driver may well accept
parameters for readahead settings etc, either thro
d with a SQL query but hopefully this shouldn't happen to
most people.
Hope this helps.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
times a day.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I have not been able to use the tuning wizard in windows for postgresql
8.4 since it stops postgres starting so I have been looking to tweak the
postgresql.conf file directly. I am happy with the performance of
postgres in general but I feel that it is not utilising the memory on my
serve
Howard Cole wrote:
Hi,
I have not been able to use the tuning wizard in windows for
postgresql 8.4 since it stops postgres starting so I have been looking
to tweak the postgresql.conf file directly. I am happy with the
performance of postgres in general but I feel that it is not utilising
of 2 to 8 - checking the number
of connections at the time, they do not appear to be overloaded.
I am running 8.4.1 on Windows 2K3 with a C# application using Npgsql.
All connections are to the localhost and there is no firewall.
Help!
Howard Cole
www.selestial.com
--
Sent via pgsql-general
Richard Broersma wrote:
On Tue, Dec 1, 2009 at 7:52 AM, Howard Cole wrote:
I am getting many entries in my log of this type:
2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection
2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection
could be made because
Howard Cole wrote:
Interesting what Francis says about the pool connections being closed
before disposal.
Apologies "Francisco"
Presumably I should never get this error if I use Npgsql?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
Francisco Figueiredo Jr. wrote:
Presumably I should never get this error if I use Npgsql?
That's correct. But there may be a bug in Npgsql code itself.
That's why I asked you to try to raise minpoolvalue to check if you
see less errors.
I hope it helps.
Thanks Francisco - I curren
Does anyone know of a replication solution that can handle large
objects? Preferrably on a per database rather than per cluster basis.
Incidentally - out of interest - why doesn't Slony handle large objects?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-genera
Howard Cole wrote:
Thanks Francisco - I currently have MinPoolSize set to 3 (I have a lot
of databases on this cluster), I think this copes 90% of the time but
I shall set it to 10 and see what happens.
Sampling the number of connections on my database I decided that the
number of
David Boreham wrote:
Sampling the number of connections on my database I decided that the
number of connections settled at 6 so I changed my MinPoolSize from 3
to 6. I checked the current state of the database and the number of
connections is currently 12. Tonight I shall change the MinPoolSize
Stumbled across this post by Joe Stagner of Microsoft:
http://misfitgeek.com/blog/aspnet/php-linux-windows-asp-net-performance-ndash-redux/
It is basically a comparisson of ASP.NET vs PHP but it includes
comparissons of multiple RDBMS and operating systems.
Postgres comes out on top for most
a.bhattacha...@sungard.com wrote:
Hi All,
I have my application UI in Java and which is communicating with
Postgresql database.
However whenever my application is running I could see there are too
many postgres.exe are created even though the application is not doing
anything in databas
Phoenix Kiula wrote:
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's archives but could not come up with an answer.
Google returns some sites like these:
http://
Greg Smith wrote:
Howard Cole wrote:
Postgres comes out on top for most of the benchmarks against MySQL
and SQL Server, in fact in the authors original article he goes as
far as recommending using Postgres. More interestingly, the article
seems to indicate that W2K8 server is faster for
Phoenix Kiula wrote:
On Tue, Dec 15, 2009 at 9:26 PM, Howard Cole wrote:
Phoenix Kiula wrote:
An easy question for some I hope.
I have a DB from 8.2 days that when I now dump and try to take into
the 8.3.7, it gives me errors about utf-8 stuff.
I tried searching this list's arc
t text is of the format '{doc}' for example - as in a set or
similar.
Is there an alternative I can use to extract just the extension as a
string, and to update the non matching columns, setting them to null
or empty string?
Thanks.
Howard Cole
www.selestial.com
Aha! Found it:
upda
something obvious - or is it a waste of time using the
pgbench as a judge of optimisation in these circumstances?
Thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Leif Biberg Kristensen wrote:
On Thursday 14. January 2010 16.02.12 Andy Colson wrote:
See my reply above. My 250 tps seems in line with the 700 tps on a modern
system that the OP gets on his Windows setup. To me it seems like something is
broken on his Ubuntu setup.
regards,
I am hopin
Leif Biberg Kristensen wrote:
On Thursday 14. January 2010 16.55.07 Howard Cole wrote:
Leif Biberg Kristensen wrote:
On Thursday 14. January 2010 16.02.12 Andy Colson wrote:
See my reply above. My 250 tps seems in line with the 700 tps on a modern
system that the OP gets on his
to only accept secure connections.
Howard Cole
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
my_only_table_that_uses_large_objects)
Or are there other things stored in there that I don't know about!
Thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
George Weaver wrote:
My objective it to read a large object into memory as opposed to
exporting it to a disk file.
I'm using version 8.3.3, psqlODBC 8.2.2 and vb.net.
If you use Npgsql (.NET library) rather than ODBC - there are functions
for reading large objects into memory.
H
f the object so
I am going to convert these bytea's to large objects so I can chunk the
data.
Thanks,
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Thank you very much. (P.S. Npgsql is great!)
Thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I am in the process of updating a database from 8.2 to 8.3 and need a
little help with the tsearch2 update.
Prior to restoring my 8.3 backup, I ran the tsearch2.sql on the new
database, however I am having a little problem with triggers - when I
run an update on a table I get the followi
RTFM!
Just read the part about ditching the tsearch2 function. Sincere apologies.
Howard.
Howard Cole wrote:
execute procedure tsearch2('fts','column1','column2');
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
could do a differential backup of the dumped files.
Thanks
Howard Cole
http://www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
clever! It gives me an inferiority complex ;)
Howard.
Howard Cole
http://www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Raji Sridar (raji) wrote:
Hi,
I would like to know if Postgres 8.2.x is supported on Windows 2008 (32
bit). If not, what is version of Postgres supported on Windows 2008? PLs
let me know.
Thanks
Raji
Hi Raji,
Windows Server 2008 is excellent (Sorry if I upset any *nix fanbois).
And has
Hi,
I am running postgres 8.3 on a W2K8 server and appear to be getting lots
of "cannot reattach to shared memory" errors in the log. I used to get
these before on a windows 2K3 server but I was under the impression that
these were caused by ESET NOD32 antivirus software. But I am not running
Hi,
Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot
find contrib/tsearch2.sql - I need to import an 8.2 backup with the old
tsearch2 but cannot find the new compatibility layer sql file.
Where is it???
Thanks,
Howard Cole
www.selestial.com
--
Sent via pgsql-general
Raymond O'Donnell wrote:
On 18/05/2009 23:28, Howard Cole wrote:
Just installed 8.3.7 on a W2K3 machine using the pginstaller. I cannot
find contrib/tsearch2.sql - I need to import an 8.2 backup with the old
tsearch2 but cannot find the new compatibility layer sql file.
Hi
Please help :(
I have tried to install postgres 8.3.7 on three machines using the
pginstaller and none of them appear to install the contrib/tsearch2.sql
file.
If I look at my old installations (8.3.4 and 8.3.6) then the
contrib/tsearch2.sql file is there.
Is there a problem with my insta
Sam Mason wrote:
On Wed, May 20, 2009 at 06:22:46PM +0530, Gurjeet Singh wrote:
I don't know if the following would be recommended, but did some research
and it seems that one can use STOP and CONT signals on Linux/Unix to
pause/continue a process.
As David noted; sending a STOP is exa
driver and the
*nix one?
The .NET driver (npgsql) is mature and excellent - I am not sure how you
integrate it with Delphi but for Microsoft .NET environments it is
brilliant. The ease of programming in .NET would make me select it over
ODBC every time.
Howard Cole.
--
Sent via pgsql-gener
Howard Cole wrote:
Please help :(
I have tried to install postgres 8.3.7 on three machines using the
pginstaller and none of them appear to install the
contrib/tsearch2.sql file.
If I look at my old installations (8.3.4 and 8.3.6) then the
contrib/tsearch2.sql file is there.
Is there a
transactions per dollar an interesting statistic
when comparing the Postgres and MySql!
I look forward to seeing the results.
Howard Cole
www.selestial.com
Rick Schumeyer wrote:
I’m interested in comparing the performance of postgresql and mysql
on various combinations of user loads and database
Have you tried a cross join with a where statement as an alternative?
e.g. select
select i.internalid, c.code
from local.internal i, country.ip c where i.ip between c.startip and c.endip;
Howard Cole
www.selestial.com
Jesse D. wrote:
select i.internalid, c.code
from local.internal i
inner join
am genuinely interested in the results.
Howard Cole
www.selestial.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I have been using the npgsql driver on both .NET and Mono for over 6
months now with no problems.
Howard Cole
www.selestial.com
Philippe Lang wrote:
Does anyone successfully use a .Net Data provider for Postgresql? I was
able to find two of them:
---(end of
The Npgsql driver does have windows forms integration, but I do not use
this part or know if it is compatible with VS 2005. Try the
documentation or check the npgsql user list
([EMAIL PROTECTED]).
Howard Cole.
www.selestial.com
Philippe Lang wrote:
Is there a way to install the npgsql
Hi,
Should it be possible to create a compressed backup of a version 8.0.1
database running on linux and restore that backup on version 8.0.3
running on XP? I ask this because it does not seem to work for me. Many
problems seem to arise to do with tsearch2 extensions to tables, even
though ts
foreign key checks for the duration of the restore?
Howard
www.selestial.com
Howard Cole wrote:
Hi,
Should it be possible to create a compressed backup of a version 8.0.1
database running on linux and restore that backup on version 8.0.3
running on XP? I ask this because it does not seem to
can't find tsearch2 types.
My head hurts.
I shall try to manually hack the plain backup file to remove references
to the tsearch2 tables.
Will all of these problems disappear if I upgrade the linux machine to
8.0.3?
Howard.
www.selestial.com
Howard Cole wrote:
To improve compatibili
Thanks for the response Doug. I am frightened to upgrade the linux
machine to 8.0.3 at the moment because the server is live and I want to
make sure that 8.0.3 will fix it. I have extracted the relevant parts of
the restore as follows:
1. The restore command
pg_restore.exe -i -h 10.202.6.1
what happens!
Howard Cole
www.selestial.com
CREATE OR REPLACE FUNCTION dex_init(internal)
RETURNS internal AS
'$libdir/tsearch2', 'dex_init'
LANGUAGE 'c' VOLATILE;
ALTER FUNCTION dex_init(internal) OWNER TO postgres;
Howard Cole wrote:
CREATE OR
1
database directly, and then the restore would have worked, but as I said
before this was a live system so I did not want to fiddle.
There is now an issue with case sensitivity. But I will start that in a
clean thread.
Regards.
Howard Cole
www.selestial.com
Tom Lane wrote:
Howard C
ct * from test where val < 'a';
Results on 8.0.1 linux server (UNICODE)
val
-
(0 rows)
Results on 8.0.3 windows server (UNICODE)
val
-
A
(1 row)
I am guessing that the 8.0.3 on windows is the correct version - but
what changes this and how can I set it?
regar
?
Regards,
Howard Cole
www.selestial.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
1 - 100 of 127 matches
Mail list logo
