On Apr 2, 2015, at 5:09 PM, Octavi Fors wrote:
>
> And second, because I need the database to be accessible from two computers
> in the same LAN.
If you do this, you will destroy your database[1].
Why not have the database running on one machine, all the time, potentially
with a real disk s
On Apr 5, 2015, at 1:21 PM, Ray Madigan wrote:
> I have been using postgresql in java off and on for many years. I now have
> an assignemtn where I have to build a very straight forward networked
> application that needs to be able to insert Array data types from a windows
> environment to
On Apr 23, 2015, at 10:09 AM, Cory Tucker wrote:
> I have the need to move a specific set of data from one schema to another.
> These schemas are on the same database instance and have all of the same
> relations defined. The SQL to copy data from one table is relatively
> straightforward:
> On Jun 10, 2016, at 1:01 PM, Ken Tanzer wrote:
>
> Hi. I was hoping this list might be able to offer some
> help/advice/suggestions/opinions about feasibility for something I want to
> implement, namely converting Postgres constraints into PHP logic. Here's the
> context and explanation:
> On Jun 17, 2016, at 3:03 AM, Alex John wrote:
>
> Hello, I have a few questions regarding the use of PostgreSQL and HIPAA
> compliance. I work for a company that plans on storing protected health
> information (PHI) on our servers. We have looked at various solutions for
> doing
> so, and RDS
> On Sep 6, 2016, at 12:08 PM, Scott Marlowe wrote:
>
> On Fri, Sep 2, 2016 at 9:38 PM, Pradeep wrote:
>>
>> max_connections = 100
>> shared_buffers = 512MB
>> effective_cache_size = 24GB
>> work_mem = 110100kB
>
> This is WAY too high for work_mem. Work_mem is how much memory a
> single sort
> On Oct 26, 2016, at 6:59 AM, Tim Smith wrote:
>
> Hi,
>
> I'm curious as to what the current advice would be in relation to
> auto-complete type applications (e.g. "AJAX" type java-script "guess
> as you type" applicatoins).
>
> In relation to text fields, I know the general suggestion is gi
I'm looking for generic advice on hardware to use for "mid-sized" postgresql
servers, $5k or a bit more.
There are several good documents from the 9.0 era, but hardware has moved on
since then, particularly with changes in SSD pricing.
Has anyone seen a more recent discussion of what someone mi
> On Dec 3, 2016, at 3:57 PM, Samuel Williams
> wrote:
>
> Thanks everyone for your feedback so far. I've done a bit more digging:
>
> MySQL in MBytes (about 350 million rows):
>
> index_user_event_on_what_category_id_created_at_latlng | 22806.00
> index_user_event_for_reporting | 18211.00
>
> On Dec 10, 2016, at 11:32 AM, Igor Korot wrote:
>
> Hi, guys,
> I'm working thru my script and I hit a following issue:
>
> In the script I have a following command:
>
> CREATE TABLE playersinleague(id integer, playerid integer, ishitter
> char, age integer, value decimal, currvalue decimal,
> On Dec 27, 2016, at 2:03 PM, Guyren Howe wrote:
>
> I am putting together some advice for developers about getting the most out
> of SQL servers in general and Postgres in particular. I have in mind the
> likes of most web developers, who through ignorance or a strange cultural
> preference
> On Jan 11, 2017, at 7:02 PM, David G. Johnston
> wrote:
>
> "throughout" mustn't mean "by other sessions" or this becomes unwieldy.
>
> Here's a mock-up:
>
> CREATE TABLE template_table ();
> CREATE VIEW view_over_my_template_instance AS SELECT * FROM
> my_instance_of_template_table; --fa
> On Jan 17, 2017, at 10:23 AM, Rich Shepard wrote:
>
> Running -9.6.1. I have a database created and owned by me, but cannot copy
> a table to my home directory. Postgres tells me it cannot write to that
> directory. The only way to copy tables to files is by doing so as the
> superuser (postg
> On Jan 20, 2017, at 7:03 PM, bto...@computer.org
> wrote:
>
> While learning a bit about basic hot standby configuration, I was reviewing
> an article that used these parameters
>
> wal_level = 'hot_standby'
> archive_mode = on
> archive_command = 'cd .'
> max_wal_senders = 1
> hot_standby
> On Feb 1, 2017, at 4:03 PM, John R Pierce wrote:
>
> On 2/1/2017 3:39 PM, postgres user wrote:
>> If I have the Postgresql server installed on my machine i.e I have all the
>> bins, libs and share directories of the Postgresql and I have the libs and
>> sql's installed for one of the contrib
I have an app that would benefit from being able to use pg_partman rather than
doing it's own ad-hoc partition management.
Unfortunately, some of the places where the app needs to run don't have root
access to the database server filesystem, so I can't install the extension in
the postgresql ex
> On Apr 27, 2016, at 2:47 PM, Adrian Klaver wrote:
>
> On 04/27/2016 01:22 PM, Steve Atkins wrote:
>> I have an app that would benefit from being able to use pg_partman rather
>> than doing it's own ad-hoc partition management.
>>
>> Unfortunately, som
> On Apr 27, 2016, at 3:47 PM, Adrian Klaver wrote:
>
> On 04/27/2016 03:30 PM, Steve Atkins wrote:
>>
>>>>
>>>> Is there any way to install an extension either from a SQL connection or
>>>> from a user-defined directory instead of .../ex
> On Apr 28, 2016, at 6:44 AM, Vik Fearing wrote:
>
> On 04/27/2016 10:22 PM, Steve Atkins wrote:
>> Is there any way to install an extension either from a SQL connection or
>> from a user-defined directory instead of .../extensions?
>>
>> (And if not, is
> On May 11, 2016, at 11:24 PM, Martijn Tonies (Upscene Productions)
> wrote:
>
> Hello everyone,
>
> I’ll just get at it right away --
>
> We’re developing a database development tool called Database Workbench, it
> currently supports MySQL, InterBase, Firebird, Oracle, SQL Server, NexusD
> On May 20, 2016, at 1:43 PM, Guyren Howe wrote:
>
> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue
> wrote:
>>
>> Le 04/05/2016 18:29, Szymon Lipiński a écrit :
>>> On the other hand, when I was trying to store all my logic in a
>>> database, there was just one thing that made me hat
On Jun 4, 2007, at 11:15 AM, Ben wrote:
On Mon, 4 Jun 2007, Joshua D. Drake wrote:
Ben wrote:
I'm trying to move my WAL to another drive, but am having
difficulties with this seemingly simple process. Every time I
start up with pg_xlog symlinked to my other drive, I get this:
FATAL: coul
On Jun 5, 2007, at 7:28 AM, Ron Johnson wrote:
On 06/05/07 08:59, Alvaro Herrera wrote:
Ron Johnson wrote:
On 06/04/07 17:54, Guy Rouillier wrote:
Many people consider two-way encryption to be insecure; two-way
encryption means you can decrypt a value if you know the key,
and it is insecu
On Jun 11, 2007, at 10:44 AM, Gabriele wrote:
I'm going to develop a medium sized business desktop client server
application which will be deployed mostly on small sized networks and
later eventually, hopefully, on medium sized networks.
It will probably be developed using C#.
I do need a soli
On Jun 17, 2007, at 2:15 PM, Sergei Shelukhin wrote:
This is my first (and, by the love of the God, last) project w/pgsql
and everything but the simplest selects is so slow I want to cry.
This is especially bad with vacuum analyze - it takes several hours
for a database of mere 15 Gb on a fast
On Jun 20, 2007, at 12:07 PM, Sean Murphy wrote:
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
You can use pl/perlu or any of the other untrusted language
On Jun 23, 2007, at 11:06 AM, Magnus Hagander wrote:
I fully agree with the not part of the default installation. And
make it
easy to turn the thing off.
In that respect it sound like a good feature for developer systems
(not
servers per se). Just ensure for a small memory footprint, pr
On Jun 23, 2007, at 8:47 PM, gary jefferson wrote:
Is there a way to use a variable as the name of a table or column
in plpgsql?
This might be a simple question, but I can't find the answer in the
docs. http://www.postgresql.org/docs/8.2/interactive/plpgsql-
declarations.html
hints that t
On Jul 2, 2007, at 3:36 PM, Postgres User wrote:
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200
On Jul 12, 2007, at 10:07 AM, imageguy wrote:
I am building an application with Postrges as the backend foundation.
This is my first application and it has struck me that as we add
features/functionality to the application and database with each new
version, we will need some method of obtainin
On Jul 13, 2007, at 6:39 PM, Madison Kelly wrote:
Hi all,
I am reading through some docs on switching to Postfix with a SQL
backend. The docs use MySQL but I want to use PgSQL so I am trying
to adapt as I go. I am stuck though; can anyone help give me the
PgSQL equiv. of:
SELECT CONC
On Jul 16, 2007, at 11:36 AM, Michael Nolan wrote:
I have data (from an external source) which is in text format as a
hex number (it's actually an IP address, but that's probably not
relevant.)
It likely is relevant, as it means it's a 32 bit unsigned integer,
which isn't something postg
On Jul 17, 2007, at 8:09 AM, Rick Schumeyer wrote:
I've read the earlier threads on whether to store images in the
database or filesystem. I think I understand the pros and cons of
each method, but I have a question on a specific use case.
Let's say I have a web app, and I want to display
On Jul 22, 2007, at 11:26 PM, novnov wrote:
The answer may or many not be very postgres specific but...what are
some
possible routes that I could take to allows users to upload data
from excel
into a postgres via a website? I've never tried anything like this
before.
Are there standard
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
Please forgive me if this question is being asked in the wrong area
(and
please suggest the proper one so I can ask there :-) ), but I'm in
search of
assistance in moving a database from a Solaris system over to a
Windows
system.
Solaris
On Aug 7, 2007, at 1:17 AM, Sergei Shelukhin wrote:
Ok here's the update after ~30 hours we have killed vacuum full and
did vacuum on the tables we freed.
However, VACUUM hasn't freed any space at all 0_o
We want to launch vacuum full on per-table basis but we can't have any
more downtime right
On Aug 8, 2007, at 11:13 AM, Gauthier, Dave wrote:
If I have a DB called “foo”
...and...
I want to run “select name from table_a where name like ‘john%’”
...and...
I want no table header “NAME” in the output
...and...
I want to do this as a one-liner from the linux command line
...and...
On Aug 16, 2007, at 9:35 AM, Madison Kelly wrote:
Note: This is being sent again (in case it shows up later). It
never seemed to have made it to the list.
Hi all,
I'm using ulogd with PostgreSQL which stores IP addresses as 32bit
unsigned integers. So when I select some data I get somethi
On Aug 24, 2007, at 2:18 PM, Matthew wrote:
Hey Bill,
It does not.
Bummer.
To get your columns in a specific order, specify the column names in
that order in your SELECT statement. The SQL standard doesn't
provide
for any other way to guarantee column order, and neither does
On Sep 5, 2007, at 9:59 AM, Steve Crawford wrote:
I've dug through the docs and peeked at the source and found no way to
specify a connect_timeout so:
1. Did I, in fact, just overlook something?
PGCONNECT_TIMEOUT=5 psql ?
There are a lot of useful environment variables that libpq and
anythi
On Sep 11, 2007, at 2:48 AM, Gregory Stark wrote:
"Ron Johnson" <[EMAIL PROTECTED]> writes:
On 09/10/07 19:50, Tom Lane wrote:
This whole sub-thread actually is predicated on an assumption not
in evidence, which is that there is any browser anywhere that will
tell the http server timezone i
On Sep 12, 2007, at 4:32 PM, Andrew Hammond wrote:
Does anyone know where I could find a tool which allows importing
schema information from a postgres database into visio? The boss
guys want some pretty pictures...
Visio has that built-in for a long time - point it at the database
via O
On Sep 17, 2007, at 9:50 AM, Bima Djaloeis wrote:
Hi there,
I am new to PostgreSQL, is it possible to create something so that
1) If I insert / update / delete an item from my DB...
2) ... an awk / shell / external program is executed in my UNIX
System?
If yes, how do I do this and if no,
On Oct 9, 2007, at 6:34 AM, [EMAIL PROTECTED] wrote:
Hi !
I am using postgreSQL v8.1.5 with latest odbc driver v8.02.0500.
I have very slow request between my server and my client. They are
both on the same switch 100Mb/s. I have no particular network
problems.
I use the pgadmin tool to do my r
On Oct 19, 2007, at 7:37 PM, Scott Marlowe wrote:
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure
for all LEFTs and RIGHTs in a table, that is it is i
On Oct 23, 2007, at 1:43 PM, Kevin Hunter wrote:
Hullo List,
What does Postgres offer in terms of statistics support (not the
statistics about the database, but functions to operate on the data).
I know there are simple things like AVG, COUNT, MAX, and MIN, but
what else?
I'm not sure whe
On Nov 9, 2007, at 8:52 AM, Tom Hart wrote:
I'm sure you guys have heard this about 100 times, and I've done
some research on Google and found out some things, but I still have
a couple questions.
As I'm sure you may have guessed from the subject, I'm trying to
schedule (under windows) p
On Nov 15, 2007, at 8:57 AM, Andrew Sullivan wrote:
On Thu, Nov 15, 2007 at 10:41:23AM -0600, Tony Caduto wrote:
So if you are using Oracle do you have to go through the hassle of
finding it, then compiling and installing it?
This canard comes up every time we discuss keeping the codebase
On Nov 20, 2007, at 3:41 PM, Tom Lane wrote:
"Sander Steffann" <[EMAIL PROTECTED]> writes:
From: "Harald Fuchs" <[EMAIL PROTECTED]>
Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and
be happy.
I would be happy if it would support IPv6 :-) Are there plans to
make ip6r
or so
On Nov 24, 2007, at 8:17 AM, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/24/07 09:12, Scott Marlowe wrote:
On Nov 24, 2007 5:09 AM, Clodoaldo
<[EMAIL PROTECTED]> wrote:
I will build a cheap server and I'm in doubt about what would the
the
best for performance:
On Nov 27, 2007, at 3:15 AM, Pau Marc Munoz Torres wrote:
Hi
Recently i created an index in a table using a function (not a
column) as following
create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));,
now, i would like to perform a query using this index, something like
Select
On Dec 7, 2007, at 6:29 AM, Ted Byers wrote:
--- Erik Jones <[EMAIL PROTECTED]> wrote:
On Dec 6, 2007, at 2:36 PM, Ted Byers wrote:
[snip]
What you want to do here for handling the update v.
insert is called
an "UPSERT". Basically, what you do is run the
update as if the row
exists and ca
On Dec 8, 2007, at 7:54 AM, John D. Burger wrote:
So two design patterns for a makeshift UPSERT have been presented -
one is to check beforehand, and only insert if the item isn't
present already
... which will give the wrong results if there's any concurrent
updates...
, the other is
On Dec 11, 2007, at 8:43 AM, Joshua D. Drake wrote:
On Tue, 11 Dec 2007 16:31:40 +
"Raymond O'Donnell" <[EMAIL PROTECTED]> wrote:
//
Please note in particular the following points of netiquette:
* Don't top-post, as it makes for confusing reading.
* Don't start a new thread by repl
On Dec 11, 2007, at 9:40 AM, Tom Lane wrote:
Steve Atkins <[EMAIL PROTECTED]> writes:
In the business world it's common to top-post and not cut previous
content
- and often appropriate, as it tends to be a communication between a
smaller number of people, and the uncut conte
On Dec 17, 2007, at 12:10 PM, Matthew Hixson wrote:
This may be a tad off topic, but thought a PG enthusiast might have
some insight on this. Apple Mail sits on top of Sqlite. I was
wondering if it would be possible to substitute Postgres as the
underlying database. I do know how to vac
On Dec 20, 2007, at 7:35 AM, Gordon wrote:
On Dec 19, 11:32 am, Gordon <[EMAIL PROTECTED]> wrote:
I'm a web developer who does a lot of work in PHP. The back end
database we use is bases on Postgres. I am trying to set my new
MacBook Pro up as a development system.
I have managed to install
On Dec 27, 2007, at 8:58 AM, Thomas Hart wrote:
Am I the only one seeing very strange send times for the last dozen
messages or so, or is something else going on with my end (maybe my
mail server is catching up...)
It's not just you. [EMAIL PROTECTED] is reinjecting
old mail into the lis
On Jan 4, 2008, at 12:44 AM, [EMAIL PROTECTED] wrote:
Hi,
i had a rather strange crash of my server (log file at the end of my
mailling)
and i was googling for Signal 4 and read http://en.wikipedia.org/wiki/SIGILL
i am running on linux 2.6.18-5-686 and postgresql-8.1.9-0etch2.
Most (all?)
On Jan 24, 2008, at 11:21 AM, Nathan Wilhelmi wrote:
Hello - Typically case of a software guy needing to spec hardware
for a new DB server. Further typified case of not knowing exact
amount of data and I/O patterns. So if you were to spec a disk
system for a new general purpose PostgreSQL
On Nov 10, 2010, at 4:30 PM, Daniel Verite wrote:
> Filonenko Michael wrote:
>
>> I create simple mechanism to inform user about something in database
>> triggers. In my front-end I use PQsetNoticeReceiver, and display messages
>> in QTextEdit.
>> I think about multi-user environment.
On Mar 8, 2011, at 5:06 PM, Reece Hart wrote:
> I'm considering porting a MySQL database to PostgreSQL. That database uses
> MySQL's SET type. Does anyone have advice about representing this type in
> PostgreSQL?
>
> MySQL DDL excerpt:
> CREATE TABLE `transcript_variation` (
> `transcript_va
On May 30, 2014, at 5:13 PM, Quang Thoi wrote:
> Any one knows how sorting works?
>
> I am using postgresql 9.3 and runs on Linux machines.
> I see different sorting order for the same set of return data.
>
> On linux machines, databases are configured the same.
> Database have encoding set to
On Jul 10, 2014, at 5:01 PM, Don Brown wrote:
> Hello
>
> We are writing a small application and we are trying to determine if
> PostgreSQL is the right database for us.
>
> The application at this stage is only for a single user and commonly for
> persons with little computer expertise.
>
On Jul 20, 2014, at 11:09 AM, maillis...@gmail.com wrote:
> I send a nightly dump of my production database to a development server. A
> script drops the existing development database and replaces it with the
> current production copy.
>
> Each dev uses her own copy of the database. Is there
On Aug 16, 2014, at 8:49 AM, John R Pierce wrote:
> On 8/16/2014 8:41 AM, lin wrote:
>> I change the value of "unix_socket_directories" in postgresql.conf , then
>> restart the database, but it cannot connect the database used like this
>> "psql -d postgres -p 5432" , it must given the paramete
On Aug 16, 2014, at 9:01 AM, Nick Guenther wrote:
>
>
> On August 16, 2014 11:41:02 AM EDT, lin wrote:
>> Hi all,
>> I change the value of "unix_socket_directories" in postgresql.conf ,
>> then restart the database, but it cannot connect the database used like
>> this
>> "psql -d postgres -
On Aug 26, 2014, at 3:08 PM, Arze, Cesar wrote:
>
> I probably should be posting to the VMware mailing list with this question
> but I wanted to see if anyone had any insight or suggestions here. I’ve seen
> many similar issues but none of the solutions proposed there worked for me.
This migh
On Sep 10, 2014, at 12:16 AM, Dmitriy Igrishin wrote:
> Hello, David
>
> 2014-09-10 4:31 GMT+04:00 David Boreham :
> Hi Dmitriy, are you able to say a little about what's driving your quest for
> async http-to-pg ?
> I'm curious as to the motivations, and whether they match up with some of my
On Sep 10, 2014, at 2:00 PM, Daniel Begin wrote:
> First, I am a Newbie regarding PostgreSQL …
>
> I just started to look at PostgreSQL to implement a large GIS DB (1Tb). The
> data must reside in an external disk with eSATA connection and may be moved
> to different locations (and Windows
On Oct 2, 2014, at 8:04 PM, John R Pierce wrote:
> On 10/2/2014 4:37 PM, Adrian Klaver wrote:
>> On 10/02/2014 03:50 PM, john.tiger wrote:
>>> we've always installed on linux so need help with a new mac air running
>>> latest osx
>>>
>>> in the instructions it shows several methods:
>>> 1) ente
On Nov 16, 2014, at 3:52 PM, Seamus Abshere wrote:
> hi,
>
> I want to check if two similar-looking addresses have the same numbered
> street, like 20th versus 21st.
>
>2033 21st Ave S
>2033 20th Ave S (they're different)
>
> I get an error:
>
># select regexp_matches('2033 21st
On Nov 30, 2014, at 1:05 PM, Stephen Woodbridge wrote:
> Hi,
>
> I am have a problem when I format a timestamp in that it is changing the
> year. This can't be right, so either I don't understand
You're using "IYYY" which is the "ISO year", which is based on Mondays or
Thursdays or something
On Dec 13, 2014, at 10:38 PM, Michael Nolan wrote:
> Yeah, a cron job to swap pg_hba.conf files is the best solution I've come up
> with so far. It's not one web app, it's closer to two dozen of them, on
> multiple sites.
If they use persistent connections you'll also have to kill existin
On Jan 29, 2015, at 9:53 AM, Roger Pack wrote:
> On 1/29/15, Roger Pack wrote:
>> Hello. I see on this page a mention of basically a 4B row limit for
>> tables that have BLOB's
>
> Oops I meant for BYTEA or TEXT columns, but it's possible the
> reasoning is the same...
It only applies to lar
On Feb 24, 2015, at 3:50 PM, Tim Smith wrote:
>
>
> The goal being to match the longest prefix given a full phone number, e.g.
>
>
> 61234567890 would match "australia proper 61"
> whilst
> 61134567890 would match "Australia premium 6113"
> and
> 61894321010 would match "Australia - Sydney
Is the order in which the expressions in a VALUES() clause defined?
I'm doing this: INSERT INTO foo (a, b) VALUES (nextval('bar'), currval('bar'))
It works fine, but I'm wondering whether it's guaranteed to work or whether I'm
relying on an artifact of the implementation.
Cheers,
Steve
--
On Jan 13, 2013, at 2:36 PM, Tom Lane wrote:
> Steve Atkins writes:
>> Is the order in which the expressions in a VALUES() clause defined?
>> I'm doing this: INSERT INTO foo (a, b) VALUES (nextval('bar'),
>> currval('bar'))
>
>> It w
On Jan 13, 2013, at 10:27 AM, Shaun Thomas wrote:
> Hey guys,
>
> I'm not sure the last time I saw this discussion, but I was somewhat curious:
> what would be your ideal Linux distribution for a nice solid PostgreSQL
> installation? We've kinda bounced back and forth between RHEL, CentOS, an
On Jan 16, 2013, at 12:23 PM, Robert James wrote:
> Is there a recommended, high performance method to check for subdomains?
>
> Something like:
> - www.google.com is subdomain of google.com
> - ilikegoogle.com is not subdomain of google.com
>
> There are many ways to do this (lowercase and re
On Jan 25, 2013, at 8:21 AM, Gene Poole wrote:
> I'm looking for a tutorial on how to move a Oracle 11gR2 database
> that consists on 4 instances with table spaces spread across multiple file
> systems to PostgreSQL. I need to do this because most of the open source CMS
> packages do not pl
On Jan 28, 2013, at 6:45 AM, Stephen Cook wrote:
> Hello!
>
> I have convinced a client to use PostgreSQL instead of MySQL (hooray), which
> means it falls on me to install and configure it. I'm planning on doing this
> from the command line (I have SSH access).
>
> I have installed and conf
On Jan 28, 2013, at 8:47 AM, Stephen Cook wrote:
> On 1/28/2013 11:15 AM, Steve Atkins wrote:
>> You're not planning on using this in production, I hope? OS X is a very
>> solid desktop OS, but it's server variant is packed full of weird and plain
>> broken beha
On Mar 12, 2013, at 8:41 AM, Perry Smith wrote:
>
>
> One choice would be to create the database, use it, and then drop it for each
> test. I would create the database from a template that already has data
> taken from the production database (and probably trimmed down to a small
> subset o
On Mar 18, 2013, at 9:49 AM, Jeff Amiel wrote:
> In prepping for an upgrade to 9.2.3, I stumbled across this:
>
> CREATE TABLE foo
> (
> myint integer,
> string1 text,
> string2 text
> )
> WITH (
> OIDS=FALSE
> );
>
> insert into foo values (12345,'Y','N');
>
> select * from foo f wh
On Apr 11, 2013, at 5:11 AM, David Welton wrote:
> Hi,
>
> I'm going to be deploying Postgres in a semi-embedded system where end
> users might simply power the thing off from one moment to the next.
> Or the disk might start to go wonky, or any number of other problems.
> Because it's a standa
On Apr 16, 2013, at 7:50 AM, Philipp Kraus wrote:
> Hello,
>
> I use a PG database on a HPC system (cluster). My processes get a dataset
> from the database and change the row, each process is independend.
> My table shows something like: id, status, data
>
> id = PK a unqiue number
> status
On Jul 25, 2013, at 1:44 AM, Some Developer wrote:
>>
>
> When I was talking about improving speed I was talking about reducing load on
> the app servers by putting more of the work load on the database server. I
> know that it won't actually save CPU cycles (one of the machines has to do
>
On Aug 6, 2013, at 10:45 AM, JD Wong wrote:
> Hi all!
>
> I have two servers, which share a large mounted drive. I would like to share
> postgres databases between them dynamically so that when one makes changes,
> they are immediately available in the other.
>
> I tried moving the data d
On Aug 7, 2013, at 8:23 AM, Eliseo Viola wrote:
> Hello.
> I have been reading the -http://opensource.org/licenses/postgresql- to know
> if i can use PostgreSQL in a Privative Closed Commercial Software (The worst
> of the worst :P ). in the company where i work.
> Is there any restriction or
On Aug 24, 2013, at 5:15 PM, Korisk wrote:
> Hi!
> I want quick insert into db a lot of data (in form of triplets). Data is
> formed dynamical so "COPY" is not suitable.
COPY works just fine for dynamically generated data, and it's probably the
right thing to use if you're bulk loading data (
> On Feb 6, 2017, at 9:21 AM, Rui Pacheco wrote:
>
> Hello,
>
> I’m trying to implement a version of the wire protocol but I’ve hit a
> problem: whenever I send a Close Statement message to the remote, it just
> hangs indefinitely. I suspect the problem could be on my side but I can’t
> find
> On Feb 12, 2017, at 5:03 PM, Jerry LeVan wrote:
>
> Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits.
>
> I am running MaxOS Sierra.
>
> I have built the 64 bit version of the server and have loaded
> my database into the new server ( 9.6.2 ). Everything seems to b
> On Feb 14, 2017, at 2:55 PM, Patrick B wrote:
>
> Hi all,
>
> I'm simply doing an insert and I want to get the inserted id with a select.
> I'm doing this all in the same transactions.
>
> Example:
>
> BEGIN;
>
> INSERT INTO test (id,name,description) VALUES (default,'test 1','testing
>
> On Feb 14, 2017, at 8:47 PM, Shawn Thomas wrote:
>
> No it doesn’t matter if run with sudo, postgres or even root. Debian
> actually wraps the command and executes some some initial scripts with
> different privileges but ends up making sure that Postgres ends up running
> under the postgr
> On Feb 15, 2017, at 3:58 PM, Patrick B wrote:
>
> Hi all,
>
> I just got a quick question about warm-cache. I'm using PG 9.2.
>
> When I execute this statement soon after I start/restart the database:
>
> explain select id from test where id = 124;
>
> The runtime is 40ms.
>
> Then, If I
> On Feb 24, 2017, at 1:37 PM, Tom Ekberg wrote:
>
> I'm running postgres 9.6.2 (also happened on 9.3.14) and have a cron job that
> runs hourly that runs a program that does mostly postgres SELECTs on a
> different host. Occasionally I get email (not hourly) from the cron daemon
> that conta
> On Mar 1, 2017, at 8:39 AM, jonathan vanasco wrote:
>
>
> I have to store/search some IP data in Postgres 9.6 and am second-guessing my
> storage options.
>
>
> The types of searching I'm doing:
[...]
>
> 2. on tracked_ip_block, i search/join against the tracked_ip_address to
>
> On Mar 21, 2017, at 3:03 PM, Tom Ekberg wrote:
>
> I have been working with MySQL a bit (yes, I know, heresy) and encountered a
> program called mysql_config_editor. In my opinion it does a better job of
> local password management than using a ~/.pgpass file. Instead of assuming
> that a m
> On Apr 30, 2017, at 4:37 AM, Thomas Güttler
> wrote:
>
> Is is possible that PostgreSQL will replace these building blocks in the
> future?
>
> - redis (Caching)
> - rabbitmq (amqp)
> - s3 (Blob storage)
No.
You can use postgresql for caching, but caches don't require the data
durability
1 - 100 of 422 matches
Mail list logo
