on my computer I had a disk probleme, then i had to reinstall the system
(Xubuntu 12.04).
I've backuped some parts of the disk, namely /etc, /var and /home.
I wonder if I'm able to recover my past databases in
the /var/lib/postgresql/9.1/ backup.
If yes, how ?
--
Yvon
On Mon, Sep 3, 2012 at 8:30 AM, Harshitha S hershe...@gmail.com wrote:
Hi,
We are trying to introduce a thread that monitors the creation of the
trigger_file. As and when the file is created, the process that monitors
postgres server needs to be notified through the inotify API.
This is to
Hello,
i'm currently working on a project to secure a webapplication with
SELinux and I'm interessted
in SEPostgreSQL. Is this project still alive? I couldn't find any
information besides
http://wiki.postgresql.org/wiki/SEPostgreSQL_Introduction
Is anyone actively using/developing SEPostgreSQL?
Hi,
On Tue, 2012-09-04 at 09:49 +0200, Johannes Segitz wrote:
i'm currently working on a project to secure a webapplication with
SELinux and I'm interessted
in SEPostgreSQL. Is this project still alive? I couldn't find any
information besides
Hello, thank you for your replies and sorry for the delay in my replying -
On Thu, Aug 30, 2012 at 4:45 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe scott.marl...@gmail.com
wrote:
users, and currently work_mem is set to 1M (the default.) If
Yvon Thoraval wrote:
on my computer I had a disk probleme, then i had to reinstall the system
(Xubuntu 12.04).
I've backuped some parts of the disk, namely /etc, /var and /home.
I wonder if I'm able to recover my past databases in the
/var/lib/postgresql/9.1/ backup.
If yes, how ?
If you
On Tue, Sep 4, 2012 at 10:59 AM, Alexander Farber
alexander.far...@gmail.com wrote:
I'll try changing work_mem to 2MB first - once I upgrade the RAM.
And then I'll increase it up to 16MB every day as Scott proposed.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Dear Ashesh Vashi
Here enclose the installation log file.
The operating system is Microsoft windows vista Business service pack 2
language Italian
Thank for your help,
Best regards
Da: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com]
On Tue, Sep 4, 2012 at 2:49 PM, Segato Luca lseg...@prholding.it wrote:
Dear Ashesh Vashi
Here enclose the installation log file.
The operating system is Microsoft windows vista Business service pack 2
language Italian
Looks like the vbscript engine is missing or misconfigured on
Basically, I have several production databases with various data, and I have a
reports database that grabs all necessary data once a day.
Now, there is is a new requirement to have some of the data available in the
reports database as soon as it is inserted in the production database.
Hi there,
I'm running postgresql 8.4 on a debian system. I have a database that has
no object identifier types and functions in the pg_catalog,
e.g. regclass, regclassout.
What's the best way to get these in to this database? I don't want to
upgrade postgresql.
There are other databases on the
On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke r.clark...@gmail.com wrote:
Hi there,
I'm running postgresql 8.4 on a debian system. I have a database that has
no object identifier types and functions in the pg_catalog,
e.g. regclass, regclassout.
Are you sure you don't have them ? I
Returns 0 rows.
On Tue, Sep 4, 2012 at 11:41 AM, Pavan Deolasee pavan.deola...@gmail.comwrote:
On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke r.clark...@gmail.comwrote:
Hi there,
I'm running postgresql 8.4 on a debian system. I have a database that has
no object identifier types and
Albe Laurenz wrote:
Himanshu Joshi wrote:
I am getting a below mentioned strange error while logging
into
postgres from linux command prompt. It is working fine with
GUI(pgAdmin
III). I am using postgres version 8.4SS.
Himanshu
# cd /opt/PostgresPlus/8.4SS/
#
On 09/04/2012 02:15 PM, Harshitha S wrote:
Hi,
Can Latch - that postgres already uses, be used to achieve the same?
With a quick look at latches I'm not sure what that'd have to do with
file change notification.
Magnus's suggestion to use a signal - especially as one is already
understood
On Tue, Sep 4, 2012 at 3:28 AM, Rebecca Clarke r.clark...@gmail.com wrote:
Hi there,
I'm running postgresql 8.4 on a debian system. I have a database that has
no object identifier types and functions in the pg_catalog,
e.g. regclass, regclassout.
What's the best way to get these in to
Hi there
Postgresql 8.4.
I keep getting this error multiple times when I tried to access the
pg_catalog in pg_admin:
Cache lookup failed for text search parser 3722.
The logs show that the query that was being executed was: (example is one
of many)
SELECT
(SELECT t.alias FROM
On Tue, Sep 4, 2012 at 2:59 AM, Alexander Farber
alexander.far...@gmail.com wrote:
Hello, thank you for your replies and sorry for the delay in my replying -
On Thu, Aug 30, 2012 at 4:45 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe
On Tue, Sep 4, 2012 at 6:57 AM, Rebecca Clarke r.clark...@gmail.com wrote:
Returns 0 rows.
how in the world did you get yourself in that situation?
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
hi all
How could i use crostab to display variable number of columns. in the output
There could be variable number of columns
Regards
Punnoose
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/crosstab-tp5722632.html
Sent from the PostgreSQL - general mailing list
Hi ,
I believe, we need to have a Dynamic SQL for this to generate the dynamic
Crostab.. I have tried the same earlier and wrote the below Calendar Query
for the year 2011 including holidays.
Crostab Example
=
select
min(case when extract(month from d.dd)= 1 then
'Jan'
when
On 08/31/2012 01:05 PM, Andrew Sullivan wrote:
..Anyone who thinks that
MySQL, with its sketchy guarantees of data integrity and persistence,
is mainstream-acceptable but Postgres isn't because they haven't read
about it in InfoWorld
And if they want to read about it in InfoWorld, they can:
Has anyone tried developing a PLR procedure to do the equivalent of crosstab
but using the Reshape library from R? The reason I ask is that I have been
extracting tables like this with an R script, using RPostgreSQL, then functions
from Reshape and writing the output to a .csv file. I wonder
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote:
I have been looking into heroku lately, they run on PostgreSQL -
https://postgres.heroku.com/postgres
Went out to lunch with a guy who worked for Redfin as well. I guess
they're all Postgres over there too..
--
Sent via
On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen m...@kitchenpc.com wrote:
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote:
I have been looking into heroku lately, they run on PostgreSQL -
https://postgres.heroku.com/postgres
Went out to lunch with a guy who worked for
Now that 9.2 supports index-only scans, I'm curious what possibilities
this opens up in the future.
It seems to me that the next logical step is to allow a user to put
all columns into the index, at which point you would no longer even
need the heap table. Oracle calls this index-organized
Andy Yoder ayo...@airfacts.com wrote:
I would like the community's input on a topic. The words too far
out of the mainstream are from an e-mail we received from one of
our clients, describing the concern our client's IT group has
about our use of PostgreSQL in our shop. The group in
Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
hi all
How could i use crostab to display variable number of columns. in the output
There could be variable number of columns
see the documentation for Additional Supplied Modules, in your case
tablefunc :
This is really good feature (crostab) to implement ..
Best Regards,
Dinesh
manojadinesh.blogspot.com
On Wed, Sep 5, 2012 at 12:21 AM, Vincent Veyron vv.li...@wanadoo.fr wrote:
Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
hi all
How could i use crostab to display variable
On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
hi all
How could i use crostab to display variable number of columns. in the output
There could be variable number of columns
see the documentation for Additional Supplied
On 09/04/2012 12:17 PM, Aram Fingal wrote:
On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
see the documentation for Additional Supplied Modules, in your
case tablefunc :
http://www.postgresql.org/docs/9.1/static/tablefunc.html
I evaluated tablefunc about a year and a half ago and found
On Sep 4, 2012, at 3:26 PM, Joe Conway wrote:
On 09/04/2012 12:17 PM, Aram Fingal wrote:
On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
see the documentation for Additional Supplied Modules, in your
case tablefunc :
http://www.postgresql.org/docs/9.1/static/tablefunc.html
I
On 09/04/2012 12:48 PM, Aram Fingal wrote:
So, are you saying that if I do something like this:
copy(crosstab(source_sql, category_sql)) to '/output.csv' with csv;
Then I don't have to list what the columns are going to be? In other
words, I can skip the AS (...) clause which is shown in
On 05/09/12 05:35, Scott Marlowe wrote:
On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen m...@kitchenpc.com wrote:
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak po...@verysmall.org wrote:
I have been looking into heroku lately, they run on PostgreSQL -
https://postgres.heroku.com/postgres
Went
On Sep 4, 2012, at 3:56 PM, Joe Conway wrote:
On 09/04/2012 12:48 PM, Aram Fingal wrote:
So, are you saying that if I do something like this:
copy(crosstab(source_sql, category_sql)) to '/output.csv' with csv;
Then I don't have to list what the columns are going to be? In other
words,
No,
you must use AS (..) in crosstab query...
To actually, be able to create AS on unkown data in design time, what
should produce an unknown result and unknown number of columns we are
using Dynamic SQL to build AS part... (but of course function can't return
result - just for export to csv
On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
Inside PL/R you can take the same table as it is (unpivoted) as your
data.frame and then pivot it inside R using reshape package,,, And then
inside PL/R function do whatever you would like to do with data i.e export to
whatever... - but you
On Sep 4, 2012, at 4:30 PM, Aram Fingal wrote:
On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
Inside PL/R you can take the same table as it is (unpivoted) as your
data.frame and then pivot it inside R using reshape package,,, And then
inside PL/R function do whatever you would like to
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 05/09/12 05:35, Scott Marlowe wrote:
I have read to emails to one of the postgresql lists,
where people in companies with 1000's of databases had
power failures and only the postgresql databases
restarted
That is correct,
Re you additional question re PL/R or get data from Pg in plain R - I am
not sure it will be that much faster inside PL/R...
I dont think there will be too much difference in execution time... Would
be good to test it... and would be good to share results with us :)
Thanks,
On Tue, Sep 4, 2012 at 10:39 AM, punnoose
punnoose...@dwisesolutions.com wrote:
hi all
How could i use crostab to display variable number of columns. in the output
There could be variable number of columns
Regards
Punnoose
No. The workaround I use is to write a query generator in pl/pgsql
On 09/04/2012 01:23 PM, Aram Fingal wrote:
So then, PL/R is not a solution to being able to pivot tables
directly in PostgreSQL but I might be able to define a PL/R procedure
which, for example, pivots tables and then uses the write.table()
function of R to send the results to disk without
Subject changed to describe the problem. Reply in-line.
On 09/04/2012 07:57 PM, Herouth Maoz wrote:
The issue is that when an insert or an update is fired, I can't say
whether all the segments of the same transaction have been written yet,
and if only some of them were written, there is no
On Sep 4, 2012, at 4:36 PM, A.M. wrote:
Or you could return the heatmap/plot as BYTEA data or use arrays as necessary.
I was actually thinking exactly the same thing. Part of the reason I use
PostgreSQL for all my bioinformatics work is that there is a need to correctly
associate analysis
Has anyone done that successfully? Is there any better way to sync data between
SQL server 2012 and Postgres SQL 9?
Thanks,
Claire
On 09/04/2012 02:59 PM, Aram Fingal wrote:
On Sep 4, 2012, at 4:36 PM, A.M. wrote:
Or you could return the heatmap/plot as BYTEA data or use arrays as
necessary.
I was actually thinking exactly the same thing. Part of the reason I
use PostgreSQL for all my bioinformatics work is that
Hi Joe,
Do you maybe know, is it possible inside PL/R to call another PL/R function
- but take result as R object (whatever R function returns)?
If we take this scenario for example (Take some data from DB, pivot them,
and save it as CSV)... pseudo code would be:
-Execute SQL query
-pivot
(what btw forced me to check it in plv8 - and it seems they use the same
approach internally in behind :( - though doesn't make sense because of
find_function works just with plv8 postgres functions)
Just realised I have called wrong method - so above is not true... it
returns real v8
On 09/05/2012 09:11 AM, Claire Chang wrote:
Has anyone done that successfully? Is there any better way to sync data
between SQL server 2012 and Postgres SQL 9?
If you're going to cross-post between Stack Overflow and the PostgreSQL
mailing list, please consider mentioning the fact to reduce
On 09/04/2012 04:45 PM, Misa Simic wrote:
Hi Joe,
Do you maybe know, is it possible inside PL/R to call another PL/R
function - but take result as R object (whatever R function returns)?
Mmmm, what about using plr_modules table?
It creates native R functions that get installed into your R
Excellent :)
Thanks - looks as acceptable workaround...
Many thanks,
Misa
2012/9/5 Joe Conway m...@joeconway.com
On 09/04/2012 04:45 PM, Misa Simic wrote:
Hi Joe,
Do you maybe know, is it possible inside PL/R to call another PL/R
function - but take result as R object (whatever R
On Tue, Sep 4, 2012 at 3:13 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 05/09/12 08:38, Scott Marlowe wrote:
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 05/09/12 05:35, Scott Marlowe wrote:
I have read to emails to one of the postgresql
Since this PGCon 2011 page has no slides -
http://www.pgcon.org/2011/schedule/events/361.en.html
I Googled for sharding and PostgreSQL and I found this -
http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html
On Tuesday last week we had a terrific SFPUG meeting at which Mike
Hi.
We use LISTEN/NOTIFY quite a bit but today something unusual (bad) happened.
Number of processes waiting for a lock just started to go up up up.
I finally found the object being locked was pg_listener which
RhodiumToad on IRC kindly informed happens during LISTEN/NOTIFY. The
process that
I am using regexp_matches in a function like this
create or replace function test (v_string in text) returns varchar
as $$
declare
i_strings text[];
i_stringtext[];
i_strings := regexp_matches(v_string,E'[a-zA-Z0-9:\\s\\-\\.#%
On Sep 4, 2012, at 21:39, Sergio Basurto sbasu...@soft-gator.com wrote:
I am using regexp_matches in a function like this
create or replace function test (v_string in text) returns varchar as $$
declare
i_strings text[];
i_stringtext[];
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I signalled KILL.
Aleksey
On Tue, Sep 4, 2012 at 6:21 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
Hi.
We use
On Tue, Sep 4, 2012 at 10:35 AM, Scott Marlowe scott.marl...@gmail.comwrote:
Since there's no reporting requirements for using postgresql
commercially etc, it's kind of a stealth database. It's all over the
place and nobody knows it. Meanwhile, finding qualified PostgreSQL
DBAs is pretty
On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote:
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I signalled KILL.
was this a client process or a postgres process? kill -9
On Tue, Sep 4, 2012 at 7:21 PM, John R Pierce pie...@hogranch.com wrote:
On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote:
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I
On 05/09/12 08:38, Scott Marlowe wrote:
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 05/09/12 05:35, Scott Marlowe wrote:
I have read to emails to one of the postgresql lists,
where people in companies with 1000's of databases had
power failures and only
Hi,
On 5 September 2012 12:14, Chris Travers chris.trav...@gmail.com wrote:
So people are using PostgreSQL in roles that aren't very visible anyway,
DBA's are usually coming to PostgreSQL from other RDBMS's, and few
applications are really distributed for PostgreSQL.
snip
Not only
this
On Wed, Aug 22, 2012 at 7:21 PM, Chris Travers chris.trav...@gmail.comwrote:
Does Postgres-XC support query parallelism (at least splitting the
query up for portions that run on different nodes)? They just
released 1.0. I don't know if this sort of thing is supported there
and it might be
Hi, Seref. You might want to take a look at Stado:
http://www.slideshare.net/jim_mlodgenski/scaling-postresql-with-stado
Best,
-at
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
64 matches
Mail list logo
