Hello All,
I am getting following error when trying to create new database.
createdb: database creation failed: ERROR: could not create directory
base/1923827: No space left on device
can anybody please tell me what is going wrong.
Thanks in advance.
With regards
Ashish
I guess that No space left on device explains a lot, i.e. there is no
space left on your hard drive/partition.
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.:
am Fri, dem 05.10.2007, um 11:43:09 +0530 mailte Ashish Karalkar folgendes:
Hello All,
I am getting following error when trying to create new database.
createdb: database creation failed: ERROR: could not create directory base/
1923827: No space left on device
can anybody please
Hi there,
I feel like a brain-washed person being slowly re-socialized. After
changing from an Excel-like database design to a central table one
(see here: http://archives.postgresql.org/pgsql-general/2007-10/
msg00132.php ) I am struggling with multiple problems...
One is now the HTML
am Fri, dem 05.10.2007, um 8:20:32 +0200 mailte Stefan Schwarzer folgendes:
Before I was used that the yearly values were all to be found in a
single SQL row; now for each year of each country I have a separate
row. How do I convert that into a single (HTML) row again?
You can use
And the next question coming up is: How should my query look like so
that I can sort the (HTML) table by a specific year in ascending or
descending order? So, that it doesn't display it by the country names
alphabetical order, but by, say 1998?
If you have only one row, how would you sort this
am Fri, dem 05.10.2007, um 9:13:10 +0200 mailte Stefan Schwarzer folgendes:
And the next question coming up is: How should my query look like so
that I can sort the (HTML) table by a specific year in ascending or
descending order? So, that it doesn't display it by the country names
Hi,
I have very slow performance for a TSearch2 table. I have pasted the
EXPLAIN ANALYZE queries below. 12 seconds is slow for almost any
purpose. Is there any way to speed this up?
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q
What's the best method for migrating data from my laptop to the final
server DB?
The data currently in my laptop is using SQL_ASCII encoding and the
deployment target is defaulted to using UTF-8. (should not be a concern
as the encoding should be handled via the dump right?)
However a concern
Alternately, you could have a gdp table and a fish_catch table which
would be easily joined to give the same result.
Expanding on this:
create table fish_catches (country text not null,
data_year date not null,
primary key (country,
Thank you for the fix.
--
Miroslav
Tom Lane napsal(a):
I wrote:
Bottom line seems to be that we should run through the in_info_list and
force Vars mentioned therein to be propagated up at least to the
righthand join level, ensuring they're available if we decide to
unique-ify above that
Hi list,
whenever I execute the following query as admin I get all results, but
as soon as I execute it as a less-privileged user the result is empty.
SELECT * FROM information_schema.schemata
Strange enough, when I query information_schema.tables I can see
everything both as a normal user and
Benjamin Arai wrote:
Hi,
I have very slow performance for a TSearch2 table. I have pasted the
EXPLAIN ANALYZE queries below. 12 seconds is slow for almost any
purpose. Is there any way to speed this up?
# explain analyze select * FROM fulltext_article,
to_tsquery('simple','dog') AS q
Hmmm. Don't really get that query working. My SQL looks like
this now:
SELECT
id_country,
year,
value
FROM
internet_users
NATURAL JOIN
gdp
WHERE
id_country = 8
ORDER BY
year
LIMIT
1
Ok, got it working with another proposed SQL SELECT. This is a
solution (comes out
On Oct 5, 2007, at 1:20 , Stefan Schwarzer wrote:
Before I was used that the yearly values were all to be found in a
single SQL row; now for each year of each country I have a separate
row. How do I convert that into a single (HTML) row again?
Take a look at the crosstab functions in
On Oct 5, 2007, at 4:11 , Stefan Schwarzer wrote:
Alternately, you could have a gdp table and a fish_catch table which
would be easily joined to give the same result.
Expanding on this:
create table fish_catches (country text not null,
data_year date not null,
Jan Theodore Galkowski wrote:
Does anyone know, or can anyone point to information about how much
triggers penalize inserts in PG tables? I'm getting a report that it is
substantial, and before I investigate more. The triggers in question
look like:
I use triggers everywhere. About a
Quick request to the group: we have several members who include bogus or
humorous X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off? Because they come through as
flagged messages in Outlook, it throws off my email rules processing
and the messages
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/eggyknap
On 10/4/07, Ted Byers [EMAIL PROTECTED] wrote:
--- Michael Glaesemann [EMAIL PROTECTED] wrote:
On Oct 4, 2007, at 9:30 , Ted Byers wrote:
I do not know if PostgreSQL, or any other RDBMS,
includes the ability to call on software such as
R
See PL/R:
On Oct 5, 2007, at 9:05 , Bill Bartlett wrote:
Quick request to the group: we have several members who include
bogus or
humorous X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off?
In all practicality, a request like this is futile:
* Given the
I think it's out of print, unfortunately, but by far the best quick intro
I've ever seen is: The Essence of SQL: A Guide to Learning Most of SQL in
the Least Amount of Time by David Rozenshtein.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
Benjamin Arai [EMAIL PROTECTED] writes:
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q) DESC;
QUERY PLAN
Tom Lane [EMAIL PROTECTED] writes:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
such a hokey query (how many applications really write WHERE false?),
Granted this isn't WHERE FALSE, but I certainly see WHERE TRUE all the
time in similar scenarios and I have seen WHERE FALSE.
Christian Rengstl [EMAIL PROTECTED] writes:
whenever I execute the following query as admin I get all results, but
as soon as I execute it as a less-privileged user the result is empty.
SELECT * FROM information_schema.schemata
The SQL standard specifies that information_schema.schemata shows
On 10/5/07, Michael Glaesemann [EMAIL PROTECTED] wrote:
On Oct 5, 2007, at 9:05 , Bill Bartlett wrote:
* Given it's an X- header, doesn't that mean the meaning of the value
is implementation dependent? What's bogus wrt Outlook may not be
wrt another mail system or client
* Doesn't this
am Fri, dem 05.10.2007, um 10:05:32 -0400 mailte Bill Bartlett folgendes:
Quick request to the group: we have several members who include bogus or
humorous X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off? Because they come through as
Do you
On Fri, 5 Oct 2007, Tom Lane wrote:
Benjamin Arai [EMAIL PROTECTED] writes:
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q) DESC;
QUERY PLAN
Scott Ribe wrote:
I think it's out of print, unfortunately, but by far the best quick intro
I've ever seen is: The Essence of SQL: A Guide to Learning Most of SQL in
the Least Amount of Time by David Rozenshtein.
Must be a pretty good book. Amazon has one used copy for $119.
abebooks.com
On Oct 5, 2007, at 10:56 , Bill Bartlett wrote:
* Given it's an X- header, doesn't that mean the meaning of
the value
is implementation dependent? What's bogus wrt Outlook may not be
wrt another mail system or client
* Doesn't this indicate that Outlook is broken (for some values of
broken)?
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley [EMAIL PROTECTED] wrote:
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
A
On 10/5/07, Josh Tolley [EMAIL PROTECTED] wrote:
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
A howto is available at
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
Sent: Friday, October 05, 2007 10:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 10:45 AM
To: Bill Bartlett
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn them off
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 12:30 PM
To: Bill Bartlett
Cc: A. Kretschmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn
Bill Bartlett [EMAIL PROTECTED] schrieb:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
Sent: Friday, October 05, 2007 10:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
On 10/5/07, Bill Bartlett [EMAIL PROTECTED] wrote:
Hmm ... I still use Pine on some of my really old Linux boxes -- does
this count? (Useful for reading CRON output...)
If you need / want the familiar interface of pine on a modern linux
box, look for cone.
Note that there's also an open
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley [EMAIL PROTECTED] wrote:
On 10/3/07, Goboxe [EMAIL PROTECTED] wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended
Guys,
In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote to
analyze various performance bits about PostgreSQL. I've looked everywhere and
can't find it. Does anyone know where I can find a copy, or find an equivalent
tool?
Thanks!
John
---(end
May be can help you \timing in psql
El vie, 05-10-2007 a las 21:32 +0400, John Wells escribió:
Guys,
In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote
to analyze various performance bits about PostgreSQL. I've looked everywhere
and can't find it. Does anyone
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andreas Kretschmer
Sent: Friday, October 05, 2007 12:55 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please
(Makes me have to think twice about raising
any _real_ issues though, like why my VACUUMs periodically keep
getting
into lock contentions with my JDBC connections and ultimately
causing me
to have to shut down Postgres w/ pg_ctl stop -m immediate, or how to
properly handle postmaster errors
- Felipe de Jesús Molina Bravo [EMAIL PROTECTED] wrote:
May be can help you \timing in psql
El vie, 05-10-2007 a las 21:32 +0400, John Wells escribió:
Guys,
In the book PostgreSQL (2nd ed) the author mentions a timer script
he wrote to analyze various performance bits about
I'm having a strange issue with postgres...I think.
I have the following query:
GRANT SELECT ON 'tablename' TO 'username';
As far as I can tell, thats a valid query. It works fine when I run it
under the psql command line interface and executed against a remote db.
When I try and run the
On Oct 5, 2007, at 8:32 AM, Oleg Bartunov wrote:
On Fri, 5 Oct 2007, Tom Lane wrote:
Benjamin Arai [EMAIL PROTECTED] writes:
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q)
DESC;
QUERY PLAN
Hello,
I must replicate (or synchronise) data between disconnected postgreSQL
databases ... hence a replication very asynchronous!
Application description
This an application to manage sales forces with a central application (and
postgreSQL server) where everybody in the office can connect
The MusicBrainz project replicates in a way that sounds like it could
fit your needs. It depends on a lot of perl, but if that's not a
showstopper, then maybe adapting their replication scheme would work
for you.
On Oct 5, 2007, at 5:25 PM, Laurent ROCHE wrote:
Hello,
I must replicate
47 matches
Mail list logo