On 11/09/2017 05:52 PM, chiru r wrote:
> If OpenSSL apply any patches at OS level, Is there any
> changes/maintenance we need to perform at PostgreSQL end?
>
> On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote:
>> Assuming you mean that you need only FIPS 140-2 compliant ciphers,
ng. I installed from this repo:
> http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main
>
> I was assuming someone in the Postgres project was involved in
> packaging it. Do you know who I should reach out to in that case?
I'm pretty sure Christoph Berg is at least involved. I c
You could use pg.spi.exec() from within the R procedure to grab the
arrays, do all of your processing inside R (which uses whatever BLAS
you've set it up to use), and then return the result out to Postgres.
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
n of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is this worth considering for 8.4?
Joe
---(end of broadcast)---
TIP 3: Have you
be known at parse time.
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
Alvaro Herrera wrote:
Joe Conway wrote:
It occurs to me that it shouldn't be terribly difficult to make an
alternate version of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is
n R.
R:
http://www.r-project.org/
PL/R:
http://www.joeconway.com/plr/
HTH,
Joe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mes
Kevin Kempter wrote:
Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting solutions
tahat work on top of PostgreSQL ?
I haven't used it myself, but you could check out Mondrian:
http://sourceforge.net/projects/mondrian/
HTH
Joe
--
Sent via pgsql-general mailing list (
t for some reason it just seems to ignore it in the config file.
Is there something else that needs to be present for this? I've tried
setting it in both the numeric-only and "MB" forms. I've included a
portion of the config at the end here, I realize it
Turns out someone had placed a second line further down in the file I
didn't realize was there... So it set it, then reset it.
Thanks,
Joe
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 08, 2008 8:53 AM
To: Hardwick, Joe
Cc: pgsql-general@postgresq
take
longer than usual to run and block our morning loads.. This is the first
time Postgres has had any trouble with it. Is cancelling a full vacuum
a bad idea?
I know I'm not going to find any solution to why it happened, I'm just
looking for anyone's take on it..
Thanks,
Joe
> Joe Conway <[EMAIL PROTECTED]> wrote:
>> Sorry, my bad. Fixed
Ivan Zolotukhin wrote:
Still does not work for me, HTTP timeout
Yeah, my words above were so called "famous last words".
Shortly after fixing the problem and writing that email, my ISP decided
to m
L. Can
you recomend something that works with postgres?
I've used Pentaho with pgsql and it worked pretty well. I'm pretty
sure jasper as well can work with pgsql.
It can -- just use JDBC
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
+-
2009-06-27 | 1970-07-04 00:00:00 | 2009-07-04 00:00:00
2009-06-27 | 1976-02-29 00:00:00 | 2010-02-28 00:00:00
2009-06-27 | 1962-06-27 00:00:00 | 2010-06-27 00:00:00
2009-06-27 | 1981-06-26 00:00:00 | 2010-06-26 00:00:00
2009-06-27 | 1991-07-26 00:00:00 | 2009-
I have database backup schema+data in text (non-compressed) format.
Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
I run it with "psql http://www.postgresql.org/mailpref/pgsql-general
On Thu, Sep 24, 2009 at 12:02 AM, Adrian Klaver wrote:
> On Tuesday 22 September 2009 7:28:03 pm Joe Kramer wrote:
>> I have database backup schema+data in text (non-compressed) format.
>> Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
>> I run
On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane wrote:
> Joe Kramer writes:
>> I have database backup schema+data in text (non-compressed) format.
>> Backup is created using "pg_dump -i -h ... -U ... -f dump.sql".
>> I run it with "psql
> You sure they
On Thu, Sep 24, 2009 at 1:33 AM, Tom Lane wrote:
> Joe Kramer writes:
>> On Thu, Sep 24, 2009 at 12:53 AM, Tom Lane wrote:
>>> You sure they weren't disabled in the source database?
>
>> Yes, I'm absolutely sure they are not disabled. And in the SQL dump
>
latest code from github, which works fine with 9.3:
https://github.com/jconway/plr
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU
hat it didn't need the column definition list until query
execution time, which I also doubt is possible.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mailing li
On 12/18/2013 05:14 PM, John Abraham wrote:
On Dec 18, 2013, at 3:52 PM, Joe Conway wrote:
3) Not possible -- reason was given down thread. Column definition
must be known/determinable by the parser prior to query execution.
No, wait, I think you misunderstood my idea. Can’t we have a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 12:50 PM, alexandros_e wrote:
> For some reason levenshtein_less_equal does not work,
Define "does not work", i.e. cut and paste exact SQL and output so we
can see and reproduce your issue.
Joe
- --
Joe Conway
creda
3
(1 row)
8<-
We need more specific info about how you obtained and installed the
extension.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7
4-bit"
>
> routing_nw2=# \df levenshtein_less_equal List of functions Schema
> | Name | Result data type | Argument data types | Type
> +--+--+-+-- (0
> rows)
>
> routing_nw2=#
Hmm, can we see:
\dx
and
\df
fuzzystrmatch | 1.0 | public | determine similarities and
distance between strings
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
theory,
can't say I have tried it extensively). But your method works too ;-)
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
C
the examples about 2/3rds down the page.
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuP
s is, do you see any
> optimizations?
Not exactly what you asked, but you might try PL/R with the R
"classInt" package:
http://cran.at.r-project.org/web/packages/classInt/classInt.pdf
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Sou
e the issue.
In other words, help us help you.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thu
e,produkid, onhand
from test order by 1,2',
'values (279140414),(279140421)'
)
as ct (warehousename text, p_279140414 int, p_279140421 int);
warehousename | p_279140414 | p_279140421
- -------+-+-
OFFICE
RE? )
select * from dblink('dbname=test',$$select array_agg(r) from (values
(1::int, 'today'::timestamp, 'a'::text), (2, 'yesterday', 'b'))
r(a,b,c)$$) as d(f text[]);
f
- --
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
I tried to use only %p to specify the path, but it does not seem to output the
full path according to the server log. It only starts at /pg_xlog:
archive_command = '/usr/bin/scp -B "%p"
postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/%f'
DETAIL: The failed archive co
| text| not null
Indexes:
"like_twserid_pkey" PRIMARY KEY, btree (id)
Then something like:
insert into like_twserid select * from twserid;
SELECT setval('twserid_id_seq', (select max(id) from like_twserid));
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ
'shared_buffers';
setting
-
4096
(1 row)
postgres=# select 4096 * 8 / 1024 as MB;
mb
----
32
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsq
some suggested breaking it up IIUC by catalog object type (much like
Pyrseas does) and providing, for example, access to functions that
output SQL DDL for a given object. A side effect of turning Pyrseas
into an extension could be --with some extra work-- to provide such a
set of functions. I'
programs, e.g., pgAdmin could call diff_map() to
compare database objects, Perl scripts or even a plain psql script could
call to_yaml(). And these would not depend on psycopg2, which currently
*is* a Pyrseas dependency (it would still be necessary for access to the
command line utilities).
Jo
tion in:
http://www.postgresql.org/docs/9.1/static/sql-createextension.html
http://www.postgresql.org/docs/9.1/static/extend-extensions.html
You'll notice that in the latter there is an example of a SQL-only
extension. That's why I thinking of Pyrseas as some plpython functions
as a true EX
essary.
That said, I'd think twice before using a sequence for more than one
table (unless they were part of an inheritance/partitioning scheme).
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
different file, say,
yaml2
- Use yamltodb [2] with yaml2 to generate SQL to drop the primary keys
and foreign keys, in the correct dependency order (at least that's what
it's supposed to do, make sure you use the -1 option), to a file, say, sql1
- Run sql1 through psql to drop the constraints
e:
*Speaker Full Name
*Speaker Bio
*E-mail
*Cell Phone
*Title of Talk
*Description of Talk
*Notes for Committee
For more information visit:
https://sites.google.com/site/pgdayla/
--
Regards,
Joe Conway
Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql
pg_class on (conname = relname)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
AND contype = 'p'
ORDER BY nspname, 2, conname;
The first column is the schema name, the second the table name and the
third the constraint (primary key) name.
of smallints pointing at the columns (in
pg_attribute) that form the key.
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Jul 6, 2012 at 8:51 PM, ach wrote:
> > My fastest postgresql servers have everything on one raid10, using 16 or
> > 20 15000 rpm SAS2 drives on a 1gb flash-backed cache controller.
>
> Thank you - that affirms what'd been my own growing supposition, and the
> plan
>
> > why?
>
> Really?
ot;.
select array_to_string
(
(
string_to_array
(
'aaa,bbb,ccc,ddd,eee,fff,ggg',','
)
)[1:3],','
);
array_to_string
-
aaa,bbb,ccc
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.creda
PL/R, or some hand-coded SQL statement to
build your crosstab.
But certainly if you can do all your work on the reshaped table within
the R environment, PL/R will be easier to use.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Serv
es will be applied. Postgres must be able to resolve data
types for the columns in the result, and therefore it needs you to
provide a column definition either at function creation time (via OUT
params or by explicit composite return type) or at execution time via
AS(...) clause.
Joe
--
Joe Con
faster, but it may well be more convenient if your goal is to get a
CSV file in the end anyway.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mailing list (pgsql-g
form as bytea from a PL/R function and store it in a table along with
the basic experimental info. Then later if you pass the serialized
object back into another PL/R function as a bytea argument, it gets
reconstituted as the original R object.
Joe
--
Joe Conway
credativ LLC: http://www.credat
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 install
e slide 19 here:
http://www.joeconway.com/presentations/LISA2012-PredSrvAnalytics.pdf
> beware sql injection.
good point!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsq
ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif
> */
> but still the same error occurs.
You commented out
PG_MODULE_MAGIC;
-- don't do that. Just remove the #ifdef around it.
HTH,
Joe
signature.asc
Description: OpenPGP digital signature
ion for you, but (b) is
probably far easier for you.
Joe
signature.asc
Description: OpenPGP digital signature
ian 4.3.2-1.1) 4.3.2 "
>
> Is there an effective way to identify these objects using the stats
> tables? Something like a last accessed/used or some such column?
Maybe pg_statio* views?
http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html
Joe
--
Joe Conway
cr
ary of the performance hit
and rapidly growing log though. Another idea would be to modify a copy
of 8.3.x source code (I think that's what you said you were on in an
earlier post) to emit a NOTICE with a name whenever a function is called
if it meets some criteria.
Joe
--
Joe Conway
credati
lot of PostgreSQL users in the San Diego metropolitan
area, and getting a PUG going here is long overdue. Please join up,
spread the word, and attend if you can!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting
t lead to this symptom, but it sure looks like your libldap and
> liblber are out of sync somehow.
FWIW, I just tested on fedora 13 and sure enough, I started with the
same error, and fixed it with a postgres restart.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL,
> THEN
>
> CREATE TABLE post_codes
Probably better to do:
DROP TABLE IF EXISTS post_codes;
CREATE TABLE post_codes(...);
See:
http://www.postgresql.org/docs/8.4/interactive/sql-droptable.html
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and gene
character varying(10) | not null
district | character varying(10) | not null
sector | character varying(10) | not null
Indexes:
"post_codes_pkey" PRIMARY KEY, btree (area, district, sector)
8<-
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
the table (IF EXISTS), and then create it
> "anew" - what if there is already data in the table?
Read on -- we are way past that already...
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
>
> Is postGIS a viable solution, or should I be looking at a different
> approach? Thanks for any suggestions or RTFM pointers.
If you want something simple, and not requiring PostGIS, but plpgsql
instead, see:
http://archives.postgresql.org/pgsql-sql/2003-12/msg00193.php
HTH,
Joe
-
27;);
nextval
-
1
(1 row)
select nextval('other_schema.foo_id_seq');
nextval
-
2
(1 row)
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
eturns TABLE(a int, b int) as $pgsql$
begin
a := 1;
b := 2;
return next;
end;
$pgsql$ language plpgsql;
contrib_regression=# select * from te();
a | b
---+---
1 | 2
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
T
Hello list,
I have contributed the mysql2pgsql script to the community at
http://pgfoundry.org/projects/mysql2pgsql/
I am wondering why I pg_class can see it, but " AND
pg_catalog.pg_table_is_visible(c.oid)" (as in \d korean_english)
queries are returning false. My database has been acting
://people.planetpostgresql.org/greg/index.php?/archives/88-Performing-a-reindex-of-the-system-tables.html
which was reindexing the system tables.
happily, there is no visible bad news even on running "\set verbosity verbose"
- Original Message ----
From: joe speigle <[EMAIL PROTECTED]>
T
be properly
analyzed). Our solution was similar to #3, except we didn't bother with
the flat file. We basically had a C++ process "catch" the incoming
stream of data into a memory buffer, and periodically bulk copy it into
the database using libpq COPY functions (see:
http://www.po
r not.
Thanks,
Joe
signature.asc
Description: OpenPGP digital signature
joined with other relations. There is no way around this, at least not
currently, and probably not ever in this form. If PostgreSQL ever
supports true procedures (i.e. CALL sp_crosstab(...)), then it would be
possible to forego the column definitions as joining and filtering are
not possible.
Joe
cost=0.00..19531.25 rows=557025
width=0)
I tried moving the SET statment before the cursor delcaration and
outside the transaction with the same results. I thought possibly it
was getting bogged down in I/O but the timeout seems to work fine if not
using a cursor.
What am I missing here?
Th
Hello,
I need to generate unique id which is not guessable unlike
serial(integer) type. I need an id in format like md5 hash of random
number.
On top of that I need this id to be unique across multiple tables.
Anyone had to solve this problem before? Can you post any recipes or
best practices ple
all uuid_generate_v4() does is
simply generate md5 of random number.
Thanks.
On Fri, Jan 29, 2010 at 8:31 PM, Adrian von Bidder wrote:
>
> Hi,
>
> On Friday 29 January 2010 09.20:33 Joe Kramer wrote:
>> I need to generate unique id which is not guessable unlike
>> serial(
mare.
Any suggestions?
Thanks.
On Fri, Jan 29, 2010 at 10:20 PM, Adrian von Bidder
wrote:
> On Friday 29 January 2010 11.21:00 Joe Kramer wrote:
>> We have bunch of servers running the app and rebuilding postgres with
>> support for ossp_uuid on all servers is time consuming.
>>
s.
On Fri, Jan 29, 2010 at 10:50 PM, hubert depesz lubaczewski
wrote:
> On Fri, Jan 29, 2010 at 07:20:33PM +1100, Joe Kramer wrote:
>> I need to generate unique id which is not guessable unlike
>> serial(integer) type. I need an id in format like md5 hash of random
>> numbe
Hi,
I need to store a lot of large files (thousands of 10-100 MB files)
uploaded through my web application and I find that storing them in
database as bytea field is not practical for backup purposes.
My database has full backup performed every 12 hours and backup is
encrypted and copied to serv
ly, and probably not ever in this form. If PostgreSQL ever
supports true procedures (i.e. CALL sp_crosstab(...)), then it would be
possible to forego the column definitions as joining and filtering would
not be possible in that scenario.
Joe
signature.asc
Description: OpenPGP digital signature
nd
outside the transaction with the same results. I thought possibly it
was getting bogged down in I/O but the timeout seems to work fine if not
using a cursor.
What am I missing here?
Thanks,
Joe
_
The information contained in this message is proprietary and/or confidential.
If y
ut you ignored it:
http://archives.postgresql.org/pgsql-general/2010-01/msg00287.php
Joe
signature.asc
Description: OpenPGP digital signature
t;> hello
>> world
>> \.
regression=# select * from foo;
f1 | f2
+---
1 | hello
2 | world
(2 rows)
HTH,
Joe
signature.asc
Description: OpenPGP digital signature
inful than trying to performance tune such an old release.
One thing you might try if you haven't already done so is run VACUUM
ANALYZE.
Joe
signature.asc
Description: OpenPGP digital signature
Anyone out there interested in a San Diego PostgreSQL Users Group?
If so, I created a meetup here:
http://www.meetup.com/SD-PUG/
Please sign up and contact me off list.
Thanks,
Joe
signature.asc
Description: OpenPGP digital signature
;abc');
INSERT 0 1
test=# select foo.text from foo;
text
--
abc
(1 row)
test=# select foo.name from foo;
name
--
(-1,abc)
(1 row)
HTH,
Joe
signature.asc
Description: OpenPGP digital signature
On 02/24/2010 07:16 AM, Igor Neyman wrote:
> Joe,
>
> What PG version are running?
>
> 8.2 here complains when running your example:
>
> ERROR: column foo.name does not exist
> LINE 6: select foo.name from foo;
>^
>
> ** Error *
p3', 'pwd'), ('uid3',
'app3', 'pwd');
SELECT uid, appcode FROM users, apps EXCEPT SELECT uid, appcode FROM
canaccess;
uid | appcode
--+-
uid1 | app3
uid2 | app1
uid3 | app1
uid3 | app2
(4 rows)
It could potentially get pretty ugly performance-wise as the first half
of that query is a Cartesian join.
HTH,
Joe
signature.asc
Description: OpenPGP digital signature
ne of them, someone knows if it's
> posible? And, of course, information and links are needed too.
See the SPI functions:
http://www.postgresql.org/docs/8.4/interactive/spi.html
There are examples of use in the contrib/tablefunc code among others.
HTH,
Joe
signature.asc
Description: OpenPGP digital signature
pping constraints is not so easy because the ADDs and DROPs have to
be issued in an order that takes into account inter-table/constraint
dependencies (including, in the general case, constraints that are
inherited between tables).
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgre
OR: syntax error at "pref_ban"
> DETAIL: Expected record variable, row variable, or list of scalar
> variables following INTO.
> CONTEXT: compilation of PL/pgSQL function "pref_delete_user" near line 3
What you want is: INSERT INTO pref_ban SELECT ... FROM pref_u
You may have seen this, but RedGate software is sponsoring a contest
to send a DBA on a suborbital space flight.
And there is a PostgreSQL representativeme!
https://www.dbainspace.com/finalists/joe-miller
Voting is open for 7 days. Don't let one of those Oracle or SQL Server
punks w
;
>>
>> On 12/06/2011 01:56 PM, Glyn Astill wrote:
>>> ______
>>>
>>>> From: Merlin Moncure
>>>> To: Joe Miller
>>>> Cc: pgsql-general@postgresql.org
>>>> Sent: Tuesday, 6 December 2011, 17:30
>
___
>>>>
>>>>> From: Merlin Moncure
>>>>> To: Joe Miller Cc: pgsql-general@postgresql.org
>>>>> Sent: Tuesday, 6 December 2011, 17:30
>>>>> Subject: Re: [GENERAL] PostgreSQL DBA in SPCE
note that we will also have a PostgreSQL booth in the SCALE expo
hall on Saturday and Sunday. I have a limited number of free passes I
can give out for those who help out with the expo booth. If you are
interested in helping us advocate PostgreSQL at the event, please
contact me off-list.
Thanks,
This message has been digitally signed by the sender.
_GENERAL__PGDay_SoCal___SCALE_10X.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thanks so much to everybody who voted. I really can't express my gratitude.
I'd love to head to the pub and buy everybody a drink, but I think
that might cost more than the flight.
Joe
On Tue, Dec 20, 2011 at 10:04 AM, Alban Hertroys wrote:
> On 20 December 2011 16:01, Merlin M
details see:
http://www.socallinuxexpo.org/scale10x/events/los-angeles-postgresql-day
Hope to see you there!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mailing list (p
ther user mapping options, which may include
sensitive data such as passwords, should be output by default. I'm not
sure if this should extend to other FDW-related options, since a server
option could presumably be a URI that includes logon information.
Thanks in advance.
Joe
--
Sent via pgs
t; Server
> User Mapping
> Schema
> Foreign Table
Thanks. Incidentally, what version of pgAdmin shows that? I didn't see
it in 1.14.0.
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ich distribution
(maybe I missed it though...), but given this I would guess that the R
development package is missing as well (needed for R headers and libR.so
I believe...)
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consu
of R place the shared object here:
/usr/lib/R/lib
First, go find lib.R.so. Assuming it is in the above location, place
that location in your /etc/ld.so.conf and run ldconfig.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Ser
On 05/02/2012 10:59 AM, Joe Conway wrote:
> First, go find lib.R.so. Assuming it is in the above location, place
^-- oops, I meant libR.so
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, &am
Hello all,
Accidentally, I deleted the main-database. However, the tablespace that
contains the actual data is fine. All the databases that I need are in
the table-space. Is there any way to recover these databases?
Thanking you,
Joe
--
Joe Steeve
HiPro IT Solutions Pvt. Ltd.
http
101 - 200 of 518 matches
Mail list logo
