On Mon, Apr 4, 2011 at 12:35 AM, Shoaib Mir shoaib...@gmail.com wrote:
From my limited knowledge I think we need a shared location where the master
node is putting the WAL files in and the slave nodes also look at the same
folder to get new WAL logs to replay the files. Now if we cant have that
my google-fu lead me to the following receipts:
- create HTML documentation as single file, use Calibre to convert
- use downloadable HTML-documentation, convert via Calibre (minor
problems are reported, as in wrong order of sections)
- download PDF and convert via Calibre
- download PDF and put
On 04/04/11 1:47 AM, Harald Armin Massa wrote:
my google-fu lead me to the following receipts:
- create HTML documentation as single file, use Calibre to convert
- use downloadable HTML-documentation, convert via Calibre (minor
problems are reported, as in wrong order of sections)
- download
On 4 April 2011 09:52, John R Pierce pie...@hogranch.com wrote:
On 04/04/11 1:47 AM, Harald Armin Massa wrote:
my google-fu lead me to the following receipts:
- create HTML documentation as single file, use Calibre to convert
- use downloadable HTML-documentation, convert via Calibre (minor
So my question: has anyone found a best practice solution to convert
the PostgreSQL documentaiton into a kindle-friendly format? Or has
even an .azw file downloadable somewhere?
Best wishes,
Harald
You could always send the pdf file and get it converted to kindle format,
free of cost.
Hello,
I am cleaning up a database and I have a list of unused tables, views and
column
and I want to drop these entities.
I have the following constraints:
* The database is live and thats mean I need to be able to revoke the
changes
as quick and possible.
* I need to
On 04/04/11 3:47 AM, salah jubeh wrote:
I am cleaning up a database and I have a list of unused tables, views
and column and I want to drop these entities.
suppose that table b depends on a, and let us say that other tables
depends on b.
doesn't this dependency cancel the 'unused'
Original-Nachricht
Datum: Sun, 03 Apr 2011 16:25:35 +0200
Von: Thomas Kellerer spam_ea...@gmx.net
An: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Table lock while adding a column and clients are
logged in
Sven Haag wrote on 03.04.2011 16:13:
Most probably it is . I have just analysed the dependency for one level. and I
am planning to do the restore for also one level. i.e suppose that c--b --a
if I dropped a and turned out that a is used for some reasons, I will restore a
and b only without c.
I want to do that for the
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 -
On Mon, Apr 4, 2011 at 5:40 AM, Howard Cole howardn...@selestial.com wrote:
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
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have all transferred, the problem is just the
permissions, - but how do I set up the permissions for the large
A pseudo code demonstrate it:
select * from pg_index_columns where index_name = 'x2'
Ordinal ColNameIsAsc
1 a False
2 b True
Have PGSQL same information?
AFAIK, you can pull that information from 'indexdef'
CHAR(11), the conference on Clustering, High Availability, Replication
will be held in Cambridge, UK on 11-12 July 2011.
http://www.char11.org/
Early bird bookings are available now by card or paypal only.
Call for Speakers is now open: please send your talk proposals to
spea...@char11.org by
On 4/4/2011 6:12 AM, Howard Cole wrote:
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have all transferred, the problem is just the
permissions, - but how do
On Sun, Apr 3, 2011 at 11:43 PM, Annamalai Gurusami
annamalai.gurus...@gmail.com wrote:
On 2 April 2011 11:17, John R Pierce pie...@hogranch.com wrote:
what you describe is neither postgres nor SQL
perhaps you should look at a storage engine like BerkeleyDB
I hope that not everybody
Annamalai Gurusami annamalai.gurus...@gmail.com writes:
On 2 April 2011 11:17, John R Pierce pie...@hogranch.com wrote:
what you describe is neither postgres nor SQL
perhaps you should look at a storage engine like BerkeleyDB
I hope that not everybody dismisses this mail thread because of the
Thank you all, I will take that in account
From: Scott Marlowe scott.marl...@gmail.com
To: Howard Cole howardn...@selestial.com
Cc: salah jubeh s_ju...@yahoo.com; pgsql-general@postgresql.org
Sent: Mon, April 4, 2011 1:44:28 PM
Subject: Re: [GENERAL]
On Monday, April 04, 2011 6:47:44 am Andy Colson wrote:
On 4/4/2011 6:12 AM, Howard Cole wrote:
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have
On Mon, Apr 4, 2011 at 9:31 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Annamalai Gurusami annamalai.gurus...@gmail.com writes:
On 2 April 2011 11:17, John R Pierce pie...@hogranch.com wrote:
what you describe is neither postgres nor SQL
perhaps you should look at a storage engine like BerkeleyDB
Merlin Moncure mmonc...@gmail.com writes:
On Mon, Apr 4, 2011 at 9:31 AM, Tom Lane t...@sss.pgh.pa.us wrote:
So really you should be looking at some other DBMS if you want an
embedded implementation. It'd be nice if PG could be all things to all
people, but it can't; and this is one of the
I receive a long string (about 1 per second) than content many information and
for the moment it is directly inserted in the database (1 column).
I have to treat the hole string every time i need information in it.
Now, I want split the sting and save the informations in differents fields.
I have
On 04/04/11 8:47 AM, Marc-André Goderre wrote:
1- Program a trigger function detecting the orginal insert, split the
string and fill the other field.
2- Program a web service for receiving the string, split it and insert
the informations in the db.
Witch is the fastest one (in
I receive a long string (about 1 per second) than content many information. For
the moment it is directly inserted in the database (1 column).
I have to treat the hole string every time i need information in it.
Now, I want split the sting and save the informations in differents fields.
I have
On 4/4/2011 9:19 AM, Howard Cole wrote:
On 04/04/2011 2:47 PM, Andy Colson wrote:
permissions, - but how do I set up the permissions for the large
objects?
I had the same problem. and there is no grant all... there is the new
DO though. That's what I used, a simple DO expression to iterate and
Andy Colson a...@squeakycode.net writes:
On 4/4/2011 9:19 AM, Howard Cole wrote:
Thanks Andy. As a temporary measure I am going to use the server
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
..horribly documented, inefficient, user-hostile, impossible to maintain
interpreted language..
to whom might you be alluding to
???
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
On 04/04/11 12:07 PM, Martin Gainty wrote:
..horribly documented, inefficient, user-hostile, impossible to
maintain interpreted language..
to whom might you be alluding to
I only used a few of those adjectives, and prefixed them by
hypothetical. to be honest, I would expect most languages
John R Pierce pie...@hogranch.com Monday 04 April 2011 21:20:51
On 04/04/11 12:07 PM, Martin Gainty wrote:
..horribly documented, inefficient, user-hostile, impossible to
maintain interpreted language..
to whom might you be alluding to
I only used a few of those adjectives, and prefixed
On 3. April 2011, Joshua D. Drake wrote:
On Sat, 2 Apr 2011 19:26:56 +0200, Henry C. he...@cityweb.co.za
wrote:
On Sat, April 2, 2011 14:17, Jens Wilke wrote:
Nevertheless since at least 8.4 IMO there's no need to bother
with manual vacuum any more.
Uhh, this is entirely untrue. There
When using pipe separated xpath statements to fill multiple columns of
output, there is no guarantee of correlation among the columns of the
rows returned.
Using locally built 9.0.3 (--with-libxml)
I'm dealing with an element which has one fixed attribute (@page-layout)
and either
On Monday 04 April 2011 21:07:38 Martin Gainty wrote:
..horribly documented, inefficient, user-hostile, impossible to maintain
interpreted language.. to whom might you be alluding to
???
Probably something starting with P.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On 04/04/11 12:12 PM, Leif Biberg Kristensen wrote:
Probably something starting with P.
Pascal?
Prolog??
PL/I ? ! ?
:)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi guys,
I have a problem with the implicit FOR SHARE lock which postgres seems to get
on the referenced record when there is a foreign key.
I'm using postgres 8.3.3 from debian packages.
Here is a sample database structure and commands to reproduce.
-- Test database structure
CREATE TABLE
What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'
Can't find this explained in the docs.
template1-# \dn+ pg_catalog
List of schemas
Name
On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'
Can't find this explained in the docs.
template1-# \dn+ pg_catalog
Rob Sargent robjsarg...@gmail.com writes:
When using pipe separated xpath statements to fill multiple columns of
output, there is no guarantee of correlation among the columns of the
rows returned.
Yeah, this is a known problem mentioned in our TODO list. Nobody has
any idea how to
On 04/04/2011 03:12 PM, Tom Lane wrote:
Rob Sargentrobjsarg...@gmail.com writes:
When using pipe separated xpath statements to fill multiple columns of
output, there is no guarantee of correlation among the columns of the
rows returned.
Yeah, this is a known problem mentioned in our TODO
Hi,
I'm willing to contact a PostgreSQL developer working in Holland. I
know that this is not the main reason of this list.
Please contact-me by e-mail.
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Monday 04 April 2011 21:20:51 John R Pierce wrote:
On 04/04/11 12:07 PM, Martin Gainty wrote:
..horribly documented, inefficient, user-hostile, impossible to
maintain interpreted language..
to whom might you be alluding to
I only used a few of those adjectives, and prefixed them by
On 04/05/2011 04:18 AM, Edoardo Serra wrote:
Hi guys,
I have a problem with the implicit FOR SHARE lock which postgres seems to get
on the referenced record when there is a foreign key.
I'm using postgres 8.3.3 from debian packages.
[snip]
At this point, client1 gives the following error:
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
Hey folks,
So, I'm working on a little application to help me with my
budget. Yeah, there are apps out there to do it, but I'm having
a good time learning some more too. :)
I get paid every other Friday. I thought, for scheduling
purposes in this app, that I would take a stab at
It is a very simplistic approach since you do not take into account
holidays. But if it meets your needs what you want is the modulo operator (
%; mod(x,y) is the equivalent function ) which performs division but
returns only the remainder.
N % 14 = [a number between 0 and (14 - 1)]
N = 7; 7
On 04/04/2011 07:12 PM, C. Bensend wrote:
Hey folks,
So, I'm working on a little application to help me with my
budget. Yeah, there are apps out there to do it, but I'm having
a good time learning some more too. :)
I get paid every other Friday. I thought, for scheduling
purposes
generate_series(date '2001-01-05', date '2020-12-31', interval '2 weeks')
will return every payday from jan 5 2001 to the end of 2020 (assuming
the 5th was payday, change the start to jan 12 if that was instead).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
It is a very simplistic approach since you do not take into account
holidays. But if it meets your needs what you want is the modulo operator
(
%; mod(x,y) is the equivalent function ) which performs division but
returns only the remainder.
N % 14 = [a number between 0 and (14 - 1)]
N =
Not sure if your needs are like mine, but here is the function I use. It
stores the date in a config table, and rolls it forward when needed. It
also calculates it from some know payroll date, which I'm guessing was
near when I wrote it? (I'm not sure why I choose Nov 16 2008.) for me,
generate_series(date '2001-01-05', date '2020-12-31', interval '2 weeks')
will return every payday from jan 5 2001 to the end of 2020 (assuming
the 5th was payday, change the start to jan 12 if that was instead).
And THERE is the winner. I feel like an idiot for not even
considering
Running 9.0.2 on Centos.
I just discovered this in my production error log. Starting about 45
minutes ago, I got 70 of these, within 2 seconds:
28652 2011-04-04 21:47:29 EDT [33]WARNING: PD_ALL_VISIBLE flag was
incorrectly set in relation pg_toast_49338181 page 16820
These warnings were
Thank goodness I'm still in development! I'm trying to use pg_restore with
a dump created with pg_dump. But it keeps failing with segmentation or
general protection faults. My restore command is:
$ sudo -u postgres pg_restore -d mydatabase -j8 mydatabase.dmp
I've now tried five times, and
On 05/04/11 11:18, Chris Curvey wrote:
This is on Ubuntu 10.10 server, 64-bit on Intel. I'm running Postgres
9.0.3, 64-bit from the ppa repository.
What can I do to help the developers find the root cause of this? I'm
happy to run a debug version, or find a corefile, or whatever I can,
53 matches
Mail list logo