All,
I have postgreSQL 8.0 on winXP. This morning at 7:59am, the
db system could not start.
I looked at the pg_log. Started from yesterday 1:30pm, all
log files have this line:
database system was not properly shut down; automatic
recovery in progress
Then, I restarted the PC
Hi,
My application is database intensive. I am using 4 processes since I have 4
processeors on my box. There are times when all the 4 processes write to the
database at the same time and times when all of them will read all at once.
The database is definitely not read only. Out of the entire
I have Postgres 8 on XP
Trying to recover from crash I replaced data subdirectory from backup (no
postgres backup avaliable) and re-started Postgres service.
After trying to connect to it, Postgres service terminates.
How I can recover data from this data directory ?
The following information
Hello folks
I would like to ask the following thing:
I have two functions: funcA() drops a row from table A, funcB() drops a
row from table B that references table A. funcA() calls funcB() and
issues a delete command after returning from funcB(). I get an error,
stating that it can not be
On Thu, 2005-07-21 at 07:43 +, vinita bansal wrote:
Hi,
My application is database intensive. I am using 4 processes since I have 4
processeors on my box. There are times when all the 4 processes write to the
database at the same time and times when all of them will read all at once.
# [EMAIL PROTECTED] / 2005-07-21 10:18:05 +0200:
I have two functions: funcA() drops a row from table A, funcB() drops a
row from table B that references table A. funcA() calls funcB() and
issues a delete command after returning from funcB(). I get an error,
stating that it can not be done,
I guess the next obvious question is why do you think there isn't a
user? What is the error message ?
Dave
On 21-Jul-05, at 12:38 AM, Jamie Deppeler wrote:
I am doing it right
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
Thomas F. O'Connell wrote:
Do you already have a postgres
On Thu, Jul 21, 2005 at 02:38:51PM +1000, Jamie Deppeler wrote:
I am doing it right
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
How are you determining that no user is being created? What are
you doing and what's the exact error message?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Hello all again...
While researching this locking issue I got some of the logs and found
that in one of the cases there was a SELECT running for a long time,
about 2 hours. This select statement does not usually take more than a
few seconds though, it appeared that TRUNCATE was waiting on it
Jim C. Nasby wrote:
http://www.postgresql.org/developer/roadmap
Note especially the part about developers scratching their own itch. You
can request all you want, but unless a number of developers agree it's a
good idea it probably won't make it to the TODO. And stuff can get
pulled from the
DMSoft Technologies is glad to announce Access2PostrgreSQL Pro v1.0.0
release. It converts Microsoft Access databases to PostgreSQL and vice
versa supporting Unicode and allowing user to convert data to
PostgreSQL Text file and PHP script. Conversion of Primary keys and
Indexes is supported.
Here
Added to TODO:
* Research storing disk pages with no alignment/padding
---
Lincoln Yeoh wrote:
I believe that one should leave such on-the-fly disk compression to the
O/S. Postgresql already does compression for
On Thu, Jul 21, 2005 at 19:10:03 +1000,
Ezequiel Tolnay [EMAIL PROTECTED] wrote:
* Stored procedures: Although similar to functions, SP always return an
execution status rather than a result, but provide the caller with the
equivalent of running several sql instructions, as if running a
Joe Maldonado [EMAIL PROTECTED] writes:
While researching this locking issue I got some of the logs and found
that in one of the cases there was a SELECT running for a long time,
about 2 hours. This select statement does not usually take more than a
few seconds though, it appeared that
Bruno Wolff III [EMAIL PROTECTED] writes:
On Thu, Jul 21, 2005 at 19:10:03 +1000,
* Allow to optionally prevent overloading in functions, thus allowing
the CREATE OR REPLACE command replace the function despite having
different parameters
What happens if there is more than one existing
Tom Lane wrote:
Joe Maldonado [EMAIL PROTECTED] writes:
While researching this locking issue I got some of the logs and found
that in one of the cases there was a SELECT running for a long time,
about 2 hours. This select statement does not usually take more than a
few seconds though, it
On 7/19/05, Jim C. Nasby [EMAIL PROTECTED] wrote:
CREATE TABLE sample1 (
a boolean,
b int,
c boolean
);
...it will take more storage than:
CREATE TABLE sample2 (
b int,
a boolean,
c boolean
);
Actually, I believe that's the case with just about
On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
* Stored procedures: Although similar to functions, SP always return an
execution status rather than a result, but provide the caller with the
equivalent of running several sql instructions, as if running a script.
Unlike
On Thu, 21 Jul 2005, Martijn van Oosterhout wrote:
On Thu, Jul 21, 2005 at 07:10:03PM +1000, Ezequiel Tolnay wrote:
* Create a ROWSET variable type in plpgsql that would function like a
temporary but in-memory table. Support for it would have to be added for
plpgsql's SELECT, UPDATE and
Hi there,
I know this subject has come up before many times, but I'm struggling for
hours with the following problem and none of the posts seem to have a
solution. I have a table with a good 13 million entries with
station_data=# \d speed
Table public.speed
Column | Type |
On Thu, 2005-07-21 at 02:43, vinita bansal wrote:
Hi,
My application is database intensive. I am using 4 processes since I have 4
processeors on my box. There are times when all the 4 processes write to the
database at the same time and times when all of them will read all at once.
The
Hmm, true. So I guess the real solution (once temp tables work nicely)
would be something like CREATE LOCAL TEMP TABLE where the pl/pgsql
parser invents the unusual name for you. Ofcourse, then you run into
the issue where subcalls (like using EXECUTE) won't be able to see that
table either.
What
On Thu, Jul 21, 2005 at 05:45:55PM +0200, Kilian Hagemann wrote:
Hi there,
I know this subject has come up before many times, but I'm struggling for
hours with the following problem and none of the posts seem to have a
solution. I have a table with a good 13 million entries with
Firstly,
Am Donnerstag, 21. Juli 2005 17:45 schrieb Kilian Hagemann:
Hi there,
I know this subject has come up before many times, but I'm struggling for
hours with the following problem and none of the posts seem to have a
solution. I have a table with a good 13 million entries with
station_data=#
Hi all,
I'm still working on my updateable views, which work fine now even I have a
trigger to use because my delete rules wont work, but thats not my current,
more important problem.
I use some updateable views to handle my data (which are amazingly slow), which
gives me ultimate flexibility
It is clear from the manual that c-functions can cause the dynamic loading
of .so's and that subsequent usage in the same database session will use
the already loaded function. But, when the session is done, will the loaded
function remain in the server for subsequent sessions?
When/how does a
On Thu, Jul 21, 2005 at 10:40:21AM -0700, TJ O'Donnell wrote:
It is clear from the manual that c-functions can cause the dynamic loading
of .so's and that subsequent usage in the same database session will use
the already loaded function. But, when the session is done, will the loaded
On Thu, 2005-07-21 at 09:23, Dawid Kuroczko wrote:
On 7/19/05, Jim C. Nasby [EMAIL PROTECTED] wrote:
CREATE TABLE sample1 (
a boolean,
b int,
c boolean
);
...it will take more storage than:
CREATE TABLE sample2 (
b int,
a boolean,
c
Hi,
We've been having trouble with a pgSQL 8.0.3 install
on a WXP machine. Install goes fine, DB works until we
restart the machine, then we can't connect. First time
we thought something was corrupted because we had a
power outage, we uninstalled/reinstalled and it was
fine until, again, we
This looks very strange to me:
staging= select '1.10'::cidr;
cidr
-
1.10.0.0/16
(1 row)
The normal way to read 1.10 would be as synonymous with 1.0.0.10. This is
even mandated by the POSIX spec for getaddrinfo and company. q
--
greg
---(end of
Audrey Bergeron-Morin wrote:
We've been having trouble with a pgSQL 8.0.3 install
on a WXP machine. Install goes fine, DB works until we
restart the machine, then we can't connect. First time
we thought something was corrupted because we had a
power outage, we uninstalled/reinstalled and it was
--- Matthew T. O'Connor matthew@zeut.net wrote:
Audrey Bergeron-Morin wrote:
We've been having trouble with a pgSQL 8.0.3
install
on a WXP machine. Install goes fine, DB works until
we
restart the machine, then we can't connect. First
time
we thought something was corrupted because we
I encountered an issue today in a system I'm monitoring where a DDL statement that occurred during a data import caused a pileup. I just want to see if there's anything to do other than increase available resources and wait it out or break referential integrity.Here's the basic setup:CREATE TABLE
# [EMAIL PROTECTED] / 2005-07-21 19:11:04 +0200:
I use some updateable views to handle my data (which are amazingly
slow), which gives me ultimate flexibility to handle my data.
there are some insert rules which use currval() to get the last
sequence id for my data which I have to insert.
Folks,
No doubt several/many of you are planning on attending OSCON 2005. The
PostgreSQL community will have a large, commercial booth in the exhibit
hall at OSCON this year, sponsored by SRA and CommandPrompt. And we need
you to help staff it.
Based on last year, I expect that many of us
Greg Stark [EMAIL PROTECTED] writes:
The normal way to read 1.10 would be as synonymous with 1.0.0.10.
That might be the case for IPv6, but it's never been a standard
convention for IPv4; and even for IPv6 it doesn't make any sense
for a network (as opposed to host) number.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
Tom Lane wrote:
Paul Tillotson [EMAIL PROTECTED] writes:
Tom Lane wrote:
Hardly likely, considering it's estimating only 296 rows in the subquery
output. My bet is that you've chosen a datatype whose comparisons are
not hashable (like char(n)). What is the datatype of parentid in
On Thu, Jul 21, 2005 at 06:38:01PM -0400, Tom Lane wrote:
Greg Stark [EMAIL PROTECTED] writes:
The normal way to read 1.10 would be as synonymous with 1.0.0.10.
That might be the case for IPv6, but it's never been a standard
convention for IPv4; and even for IPv6 it doesn't make any sense
An associate is using Postgresql 8 on a windows xp system. The
installation has been operating for several months and he has recently
tried installing some software and postgresql has begun refusing
connection could not receive server response to SSL negotiation packet.
Unfortunately he is
Michael Fuhr [EMAIL PROTECTED] writes:
On Thu, Jul 21, 2005 at 06:38:01PM -0400, Tom Lane wrote:
Greg Stark [EMAIL PROTECTED] writes:
The normal way to read 1.10 would be as synonymous with 1.0.0.10.
That might be the case for IPv6, but it's never been a standard
convention for
On Thu, Jul 21, 2005 at 10:14:42PM -0400, Greg Stark wrote:
Michael Fuhr [EMAIL PROTECTED] writes:
I don't know if it's ever been blessed by a formal standard
It's blessed by POSIX:
http://www.opengroup.org/onlinepubs/009695399/functions/inet_addr.html
Yep, that's lifted almost verbatim
I'm sure I've done this before, but for some reason, my main noodle is drawing
a blank. Assume we have three tables defined thusly:
create table classrooms (
id serial unique not null,
name varchar
);
create table seats (
classrooms_id integer not null references classrooms(id),
position
Greg Stark wrote:
This looks very strange to me:
staging= select '1.10'::cidr;
cidr
-
1.10.0.0/16
(1 row)
The normal way to read 1.10 would be as synonymous with 1.0.0.10. This is
even mandated by the POSIX spec for getaddrinfo and company. q
Interesting.
On Thu, Jul 21, 2005 at 10:09:07PM -0700, Benjamin Smith wrote:
select classroom.title,
count(students.id) AS students,
count(seats.id) AS seats
from classrooms, students, seats
where classrooms.id=students.classrooms_id
and classrooms.id=seats.id
Except that it counts 0s
45 matches
Mail list logo