Hi.
You could try /Access to PostgreSQL /from Bullzip.com. I liked the dump
file that this creates. Small neat and it is free!
Tommy.
It's 10 tables. that's all. No reports. I will follow your
suggestion. Thanks for the help
On Wed, May 25, 2011 at 4:25 PM, John R Pierce &
/hacking/
http://doxygen.postgresql.org/ is probably usefull too.
--
Tommy Gildseth
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
; on my system shows this:
/dev/sda2 ext39.9G 9.5G 0 100% /var
Well, the error message is pretty clear, and assuming you don't keep
your database in any non-standard location, you /var partition is indeed
full.
--
Tommy Gildseth
---
any way to
a) make the countries with NULL values appear at the bottom of the list
... ORDER BY y_2000 IS NULL [DESC], y_2000;
b) neglect the NULL values by still allowing the countries to be
displayed
Not quite sure what you mean by this.
--
Tommy Gildseth
to use more gently way
select pg_cancel_backend()
http://www.postgresql.org/docs/current/interactive/functions-admin.html
The problem is that pg_cancel_backend() is somewhat unreliable at
cancelling wayward queries. You can try other options for kill though,
other than -9, which is kind of a l
Hello,
Could someone tell me if the ‘--pwfile’ command can be applied to createdb.exe
and psql.exe?
I found a description of ‘--pwfile’ at
http://www.it-manuals.info/postgressql/app-initdb.html, which states:
--pwfile=filename
makes initdb read the database superuser's password from a file. th
Hello,
How do I specify in the command-line to access the .pgpass file when creating a
database?
I would like to use ~/.pgpass instead of –W on the command line when creating a
database (createdb) and was wondering the correct syntax.
For example,
I don’t want to have to include (-W):
"SET
client_encoding = 'SQL_ASCII';" to "SET client_encoding = 'LATIN1';"
--
Tommy Gildseth
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comman
project now that uses the postgres_fdw extensively. Do you
know if this will be fixed in 9.4? I figure it’s worth checking since 9.4 is
scheduled to be released any day now, before I start rewriting the whole
project.
Thanks,
Tommy Duek
your WHERE indexed?
What does EXPLAIN ANALYZE say?
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
privileges to superuser.
See http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-3278 and
http://www.securityfocus.com/archive/1/archive/1/471541/100/0/threaded
for more info on this issue.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22
h is what you got now, you use
sp_scheduleFromDate('2008-01-01'::date); which seems to be what the
function expects.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e from instancetable
USING imagelevel
WHERE (
(imagelevel.serparent= '1.2.840.113704.1.111.4640.1185891989.4') and
(instancetable.imageuid= imagelevel.sopinsuid)
);
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent
m laks wrote:
--- On *Tue, 6/17/08, Tommy Gildseth /<[EMAIL PROTECTED]>/* wrote:
F
How about something along these lines:
delete from instancetable
USING imagelevel
WHERE (
(imagelevel.serparent= '1.2.840.113704.1.111.4640.1185891
Ian Meyer wrote:
So I have a column that contains usernames that have characters such
as Ã(c)(R), for example: fuchÃ(c)r.. is there any way to find names
with non A-Za-z0-9?
...WHERE col ~ '[^a-zA-Z0-9]';
Someone with a bit more regex fu can probably condense down the regex.
3, without f.ex adding a call to
pg_stat_reset() in our startup scripts?
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
)
PostgreSQL doesn't have anything similar to IGNORE (afaik), but
depending on what you want to do, you may be able to work around that
with deferred constraints etc.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent via
your password in the .pgpass
file in the postgres-users home folder, on the server where the postgres
cluster is running.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ow Mun Heng wrote:
-Original Message-
From: Tommy Gildseth [mailto:tommy.gilds...@usit.uio.no]
Ow Mun Heng wrote:
I'm starting to use DBLink / DBI-Link and one of the "bad" things is that
the password is out in the clear.
What can I do to prevent it from being
Ow Mun Heng wrote:
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
On Wed, Aug 12, 2009 at 09:30, Ow Mun Heng wrote:
From: Tommy Gildseth [mailto:tommy.gilds...@usit.uio.no]
Ow Mun Heng wrote:
I'm starting to use DBLink / DBI-Link and one of the "bad&
ad no luck searching for this as rotate
usually means log rotation.
BC
Have you tried \x ?
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
e end-of-statement character:
';' or '\g' gives the usual orientation,
'\G' gives the rotated orientation.
No, that is exactly the same as \x or psql -x does.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
n up
things and free diskspace both in the table and the indexes.
It does require quite extensive locking though, so might not be an
option if you can't afford having the database unavailable for a few
(10-15) minutes.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Joao Ferreira gmail wrote:
On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote:
If I try cluster, I'm guessing I'll choose the big index and forget
about the smaller ones... is this right ?
CLUSTER will sort out all the indexes, even though you're just
clustering on
;..., 968,
0, NULL, 0
Does anyone have any further troubleshooting suggestions that I can do,
to figure out why this query have "crashed"?
The pg version is 8.2.9 on RHEL4
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Richard Huxton wrote:
Tommy Gildseth wrote:
SELECT pg_cancel_backend(17504) has no effect, neither does kill 17504
from the shell.
Strange.
I tried "strace -p17504", and this gave me just the following output:
sendto(7, "\7\0\0\0\003771\0\0\0\00224\0\0\0\017127.120.213.18&qu
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
Looks like part of your query results being sent. Is it hung in that one
system-call?
Yes, I left it there for about ~1 hour, and that was all that ever came.
Seems like you have got a network issue.
Erik Jones wrote:
On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote:
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
Richard Huxton wrote:
For what it's worth, I've run into a situation similar to this with a
client a couple time in the last week or two (I can
ng the wal-file in pg_xlog/, and trying to restart the
cluster did not work, and I found no other way to recover from this,
other than to start over again from the beginning.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
Tommy Gildseth wrote:
I've recently been testing our backup/restore procedures, and discovered
a minor inconvenience.
Running 8.2.9 btw
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
Tom Lane wrote:
Tommy Gildseth <[EMAIL PROTECTED]> writes:
After a bit of looking around, and with some help from the fine people
in #postgresql on freenode, I think I figured out what was going on.
The last wal archive file was 00010003009F, and after
finishing re
on
http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/
Tommy.
on
http://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/
Tommy.
true/false. Arrays, I don't know, since I don't use them.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
know what
they're talking about, and thinks Postgres works the same way as MySQL,
where you do indeed have to be an administrator to create triggers.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent via pgs
What I'm unable to figure out, is the steps
needed to use this for PostgreSQL?
--
Tommy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Andreas Wenk wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tommy Gildseth schrieb:
I'm trying to figure out how to use PostgreSQL's fulltext search with an
ispell dictionary. I'm having a bit of trouble figuring out where this
norwegian.dict comes from though.
Whe
Oleg Bartunov wrote:
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
I'm trying to figure out how to use PostgreSQL's fulltext search with
an ispell dictionary. I'm having a bit of trouble figuring out where
this norwegian.dict comes from though.
When I install the norwegian ispel
right track. To easy to miss the
blindingly obvious at times. :-)
Works beautifully now.
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tommy Gildseth wrote:
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice, hunspell,
probably
has better support of composite words.
Thanks
Oleg Bartunov wrote:
On Tue, 27 Jan 2009, Tommy Gildseth wrote:
Tommy Gildseth wrote:
Oleg Bartunov wrote:
Have you read
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY
We suggest to use dictionaries which come with openoffice
] [pgtest02] [:] [] [12023] [0] LOG:
autovacuum launcher started
[2009-01-29 13:55:12.011 CET] [pgtest02] [:] [] [26466] [0] LOG:
database system is ready to accept connections
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
, compiled by GCC cc (GCC)
3.2.3 20030502 (Red Hat Linux 3.2.3-59)
Oleg Bartunov wrote:
Tommy,
I tried your example and didn't find any problem.
My postgresql version is 8.3.3 and I didn't use stopwords, since I don't
have them.
arxiv=# select version();
e bug - postgres just works.
Tommy Gildseth wrote:
While trying to create a new dictionary for use with PostgreSQL text
search, I get a segfault. My Postgres version is 8.3.5
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
I tried without specifying a StopWords-list as well, but same thing happens.
Teodor Sigaev wrote:
Could you provide a backtrace? Do you use unchanged norwegian.stop file?
I'm not able to reproduce the bug - postgres just works.
Tommy Gildseth wrote:
While trying to create a new dictionar
38 in PostmasterMain ()
#20 0x00529f5b in main ()
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7;s many projects or commercial products that can compete with
that ;-)
--
Tommy Gildseth
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Andrew Gould wrote:
What does '--' do?
-- Is an SQL comment
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
in;"
You may be able to import it. IIRC, PostgreSQL doesn't do any automatic
conversion between SQL-ASCII <-> Any encoding, but if you put the
correct encoding, PostgreSQL will deal with the conversion automatically.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo,
.5 on Linux Mandrake 10.1.
Best Regards,
Tommy Svensson
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
er, and HSQLDB before, and my experience
with these led me
to beleive that SQL was case insensitive. In fact, I was so sure of it
that a case problem
just never occured to me.
- Since I could create the table I assumed it was OK and there were no
point in describing
the table.
Regards,
it for you!
/Tommy
Michael Fuhr wrote:
On Mon, Feb 28, 2005 at 12:50:25PM +0100, Tommy Svensson wrote:
- I've used Oracle, DB2, Mimer, and HSQLDB before, and my experience
with these led me
to beleive that SQL was case insensitive. In fact, I was so sure of it
that a case problem
just neve
ndeed created
with a unicode characterset
--
Tommy
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
672089) ORDER BY m_id=26250, m_id=11042,
m_id=16279, m_id=42197, m_id=672089;
--
Tommy Gildseth
http://www.gildseth.com/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
e, so that any single quotes doesn't
mess up your insert statements.
--
Tommy
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Maybe if you really want to enforce a NOT NULL constraint in mySQL, you
have to declare a column as NOT NULL DEFAULT NULL, explicitly as was
suggested somewhere else in this thread. Fascinating how they probably
thought that was a good idea.
--
Tommy
---(end of broadcas
e sort of
logic for sorting the images in this structure.
--
Tommy
---(end of broadcast)---
TIP 6: explain analyze is your friend
/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE
--
Tommy
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ence twice.
--
Tommy Gildseth
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
,
links/urls to somewhere online where I can read up on this?
Tommy
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
60 matches
Mail list logo
