> On May 7, 2017, at 9:16 AM, Adam Brusselback
> wrote:
>
> there's also pg_agent which is a cron-like extension, usually bundled with
> pg_admin but also available standalone
>
> https://www.pgadmin.org/docs4/dev/pgagent.html
>
>
> --
> john r pierce, recycling bits in santa cruz
>
> In
> On May 17, 2017, at 2:02 PM, Armand Pirvu (home)
> wrote:
>
> Hi
>
> Ran into the following statement
>
> CREATE TABLE test(
> Date$ date,
> Month_Number$ int,
> Month$ varchar(10),
> Year$ int
> );
>
>
> While it does execute, I wonder if the $ has any special me
> On Jun 1, 2017, at 9:26 AM, Louis Battuello
> wrote:
>
> Is the round() function implemented differently for double precision than for
> numeric? Forgive me if this exists somewhere in the documentation, but I
> can't seem to find it.
https://www.postgresql.org/docs/current/static/datatype
> On Jun 18, 2017, at 10:58 AM, Karsten Hilbert wrote:
>
> On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote:
>
>> Thank for this very helpful answer, which can be
>> implemented for less than $100. For somebody who started
>> working a 128k Mac in the eighties, it is mindboggling
> On Aug 2, 2017, at 9:02 AM, Edmundo Robles wrote:
>
> I mean, to verify the integrity of backup i do:
>
> gunzip -c backup_yesterday.gz | pg_restore -d my_database && echo
> "backup_yesterday is OK"
>
> but my_database's size, uncompresed, is too big more than 15G and
> sometimes
> On Sep 3, 2017, at 3:32 PM, Nico Williams wrote:
>
>
> My principal problem with psql(1) relative to NOTIFY/LISTEN is that
> psql(1) won't check for them until it has had some input on stdin. So
> it will appear to do nothing when it's idle, even if there millions of
> notifies for it to res
> On Sep 4, 2017, at 10:25 PM, Nico Williams wrote:
>
> On Mon, Sep 4, 2017 at 4:21 PM Steve Atkins wrote:
> >
>
> Me too.
>
> https://github.com/wttw/pgsidekick
>
> Select-based, sends periodic keep-alives to keep the connection open, outputs
> paylo
> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
>
> Hi, is there any way (3rd party software) to replicate particular
> schema/table not the whole database with streaming replication built-in
> mechanism ?
I don't believe so. You can do that with logical replication in v10 -
https://www.po
> On Sep 6, 2017, at 8:48 AM, Marcin Giedz wrote:
>
> Does pglogical support views replication as I can't find it in any
> restrictions ?
There's no need to replicate the contents of a view, as it doesn't contain any
data.
pglogical can replicate the initial schema, including any views, but
> On Sep 14, 2017, at 8:38 AM, Karl Czajkowski wrote:
>
> On Sep 14, vinny modulated:
>
>> If it is only one database, on one server, then couldn't you just
>> use one sequence?
>> If oyu prefix the value with some identifier of the current table
>> then you cannot get duplicates
>> across tabl
> On Sep 15, 2017, at 12:56 PM, Thelonius Buddha wrote:
>
> I’m interested to know the level of effort to build a psycopg2-like library
> for Chapel: http://chapel.cray.com/ Not being much of a programmer myself,
> does someone have an educated opinion on this?
It looks like you can call C li
> On Oct 5, 2017, at 10:28 AM, avi Singh wrote:
>
> Guys
> Any recommendation on a good CDC tool that can be used to push
> postgresql changes to Kafka in json format ?
Not sure whether json is a constraint, but I'd look at http://debezium.io and
(maybe) the no longer supported http
> On Nov 2, 2017, at 9:34 AM, Mark Fletcher wrote:
>
> Hello,
>
> Running Postgres 9.6.5, we're using logical decoding to take changes to the
> database and propagate them elsewhere in our system. We are using the PGX Go
> Postgres library, at https://github.com/jackc/pgx, and we are using th
> On Nov 9, 2017, at 9:37 AM, Poul Kristensen wrote:
>
> No it isn't.
>
> What I want to do is:
>
> ansible-playbook somepostgresql.yml
>
> and postgresql is then changed on some server
> the way things are done by e.g.
> github.com/oravirt/ansible-oracle
You're looking for help with an
On Feb 1, 2008, at 11:17 AM, Reece Hart wrote:
Folks-
A recent thread ( http://archives.postgresql.org/pgsql-general/2008-01/msg01595.php
) suggests that there's a lot of interest and knowledge about F/OSS
licenses on this list. So...
Does anyone know of an authoritative, complete, and c
On Feb 1, 2008, at 5:33 PM, Venks wrote:
Hi,
I am trying to copy some data from MySQL to Postgres using Ruby. This
is NOT a MySQL to PostgreSQL conversion project. I need to read the
data from a MySQL database and load it into PostgreSQL database.
How do I handle "nil" in ruby and convert the
On Feb 4, 2008, at 9:37 AM, Raymond O'Donnell wrote:
There's at least one website out there that offers DLLs for
download, but I have no idea whether this is legal or not. Can
anyone comment?
It's the C runtime. IIRC that's one of the redistributables, so it's
OK to distribute.
Cheers,
On Feb 11, 2008, at 11:39 AM, Marc Munro wrote:
Can someone please tell me how to extract the mix, max, increment
by, etc, values for a sequence from the system catalogs. Is this in
the manual somewhere (I couldn't find it)?
Take a look at information_schema.sequences for a list of seque
On Feb 15, 2008, at 4:49 AM, [EMAIL PROTECTED] wrote:
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each mole
On Feb 18, 2008, at 9:56 AM, Raymond O'Donnell wrote:
On 18/02/2008 17:46, Raymond O'Donnell wrote:
Well, that depends on your usage, so only you can answer that.
According to the docs, "serial" creates an integer column, which
will give you 2147483647 values - how quickly will you use th
On Feb 22, 2008, at 3:40 PM, Kynn Jones wrote:
Hi. Suppose I have a database that contains a "meta table" that
holds the names of other the tables in the database, keyed by human-
readable but longish strings. I would like to write queries that
first "compute" the names of some tables (i.
On Mar 26, 2008, at 9:37 AM, björn lundin wrote:
1) What type of names do you prefer?
d) remove them - psql is the solution
2) How often do you use these tools?
a) every day (e.g. in my cron)
3) What name of initdb do you prefer?
d) pg_ctl -d init (replace initdb with pg_ctl new
function
On Mar 26, 2008, at 7:25 AM, Zdeněk Kotala wrote:
Hello All,
I prepared patch for renaming postgreSQL script tools like createdb,
createuser, etc. to pg_createdb, pg_creteuser. Original names will
be kept for 2 or 3 following versions. The main reason for the patch
is to avoid possible cl
On Mar 26, 2008, at 10:46 AM, Alvaro Herrera wrote:
Steve Atkins wrote:
There are no existing clashes with system tools that I'm aware of.
Are
there any? Most of the clashes are with other installations of
postgresql installed on the same machine, so if name clashes is the
real
r
On Mar 26, 2008, at 12:06 PM, Tom Lane wrote:
Steve Atkins <[EMAIL PROTECTED]> writes:
On Mar 26, 2008, at 10:46 AM, Alvaro Herrera wrote:
Steve Atkins wrote:
"pg_ctl" to "safe_postgresqld",
Now that's plain weird.
Yes, it is. But if the goal is to make it
On Mar 26, 2008, at 11:44 AM, Leif B. Kristensen wrote:
On Wednesday 26. March 2008, Ron Mayer wrote:
I'd prefer a "pg" program that took as arguments
the command. So you'd have "pg createdb" instead
of "pg_createdb".
There are many precedents. "cvs update", "git pull"
"apt-get install".
An
On Mar 26, 2008, at 7:25 AM, Zdeněk Kotala wrote:
1) What type of names do you prefer?
---
a) old notation - createdb, createuser ...
2) How often do you use these tools?
---
a) every day (e.g. in my cron)
b) one per week
c) one tim
On Apr 1, 2008, at 8:56 PM, Michael Enke wrote:
Hi all,
I need to know if multiple tables have (may have most probably)
identical content.
Since I want a fast solution (which means not comparing tables row
by row),
I thought it would be a good idea to have an sql function operating
on a ta
On Apr 3, 2008, at 9:50 AM, William Temperley wrote:
Hi All
I hope this isn't a FAQ, but does anyone have any suggestions as to
how to make a query that selects using:
"where in()"
secure from an sql injection point of view?
I have grid of tiles I'm using to reference geographical points.
Thes
On Apr 21, 2008, at 7:44 PM, Christophe wrote:
Greetings,
We have the traditional three servers:
dev --> staging --> production
each with a PostgreSQL instance and the same schema, at least over
time. Right now, we handle schema migration (updating the schema
for new releases) by
On Apr 25, 2008, at 8:19 AM, Ben Chobot wrote:
On Apr 25, 2008, at 4:49 AM, Giorgio Valoti wrote:
And reorder them, too.
Why would you want to reorder an enum? It seems to me the point of
them is to hold a small list of valid values. The order the list is
described in surely should be
On May 2, 2008, at 2:01 PM, finecur wrote:
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where userid = 100
It will return millions of records which exhuas
On May 10, 2008, at 12:14 AM, Ivan Sergio Borgonovo wrote:
On Sat, 10 May 2008 07:35:36 +0200
"Pavel Stehule" <[EMAIL PROTECTED]> wrote:
your application different execution paths. Generally I can say, so
plpgsql isn't well language for this games, and better is using
plperl, plpython or othe
On May 14, 2008, at 12:56 PM, D. Dante Lorenso wrote:
I'd like to find a timestamp function that WILL change within a
transaction.
This function will return to me a 15 digit BIGINT number in base10:
SELECT FLOOR(EXTRACT(EPOCH FROM NOW()) * 10)::bigint;
The problem is that NOW() does n
On May 22, 2008, at 6:38 AM, Barbara Stephenson wrote:
Hello,
We have recently upgraded from 7.4.19 to 8.3.1. I am running Red Hat
Enterprise Linux WS release 4 (Nahant Update 6) on my laptop and I
finally
was able to install pgadmin3-1.4.3. However, when I expand my
databases, I
get tw
On May 24, 2008, at 11:57 AM, Ram Ravichandran wrote:
Hi,
I am deciding between MySQL and Postgres. I'm leaning towards
Postgres mainly due the widely publicized speed when using
transactions. However, I am not able to find any good books /
resources for tuning/ optimizing the database.
On May 28, 2008, at 8:52 AM, David Wall wrote:
What about SugarCRM?
It's nice, but it's MySQL only, with a few desiccated corpses of ports
to PostgreSQL done by third parties littered in it's wake.
vTiger is a fork / knock-off of Sugar which has sorta-kinda support
for PostgreSQL in old
On May 31, 2008, at 6:22 PM, Ram Ravichandran wrote:
Hi,
By default, my postgresql server is set to use UTF8 character set. I
was wondering if there is any way to make sure that certain fields
like url etc. only makes use of ascii. My main aim is to save space
by using only 1 byte / char
On Jun 23, 2008, at 10:56 AM, Kynn Jones wrote:
How can I find the limits (if any) on things such as the maximum
number of tables, views, indices, columns-per-table, size of
database, etc.?
(At the moment I'm particularly interested any limits that my exist
on the numbers of tables
On Jun 23, 2008, at 1:58 PM, Ian Meyer wrote:
So I have a column that contains usernames that have characters such
as Ã(c)(R), for example: fuchÃ(c)r.. is there any way to find names
with non A-Za-z0-9?
... WHERE column ~* '[^a-z0-9]'
Cheers,
Steve
--
Sent via pgsql-general mailing list
On Jun 27, 2008, at 9:53 PM, Adam Rich wrote:
"Bob Duffey" <[EMAIL PROTECTED]> writes:
I'm seeing some query plans that I'm not expecting. The table in
question
is reasonably big (130,000,000 rows). The table has a primary key,
indexed
by one field ("ID", of type bigint). Thus, I wou
On Jun 28, 2008, at 12:53 AM, Bob Duffey wrote:
If you're iterating through the records with a cursor, the plan may
be different, IIRC - weighted to provide first row quickly, as opposed
to the query that was run that's weighted to provide last row quickly.
I agree, and I was hoping that would
On Jun 15, 2009, at 8:21 PM, rodeored wrote:
I'm trying to search phone numbers for digits. Unfortunately, the
validation has been sloppy and the numbers are not just numbers, they
also have dashes and probably other stuff.
I would like the search to ignore anything but integers
WHERE (a.phone
On Jun 17, 2009, at 8:43 AM, Mike Kay wrote:
Now that's an interesting way of doing this I never thought about
before.
Using a fileserver though, how would I categorize and index the files?
I was planning on using multiple databases to hold the data - one
for each
client and a separate da
On Jun 21, 2009, at 3:37 PM, Thomas Kellerer wrote:
Mike Christensen wrote on 22.06.2009 00:10:
I just tracked down a bug in my software due to an "unexpected"
behavior in Postgres.. Can someone clarify why this doesn't work
(I haven't tried it on MSSQL or anything else, so I'm not sure if
On Jun 30, 2009, at 6:10 AM, Kaloyan Iliev wrote:
Hi
I am looking for a way to convert a text field from a table into
punycode (IDN).
Are there any buildin functions in Postgres ot in plpgsql.
It'd probably be easiest to use pl/perl and one of the punycode CPAN
modules.
Cheers,
Steve
On Jul 8, 2009, at 6:19 AM, Andreas Wenk wrote:
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method
'password' in
pg_hba.conf means, that you will be asked for a password for the
user you
try to create
On Jul 8, 2009, at 10:25 AM, Raymond O'Donnell wrote:
On 08/07/2009 18:14, Steve Atkins wrote:
Typically the postgres operating system user is allowed to
connect to the database as the postgres database user without a
password.
Is this really so? I don't think so - I think it
Oracle help for java is nothing at all to do with oracle the database,
I don't think.
It's just html-based online docs, with a web-based and standalone java
based browser.
So I'm not sure I understand the original posters question. Postgresql
is documented in docbook, and there are downlo
On Jul 20, 2009, at 10:24 AM, Bill Moran wrote:
In response to "Greg Sabino Mullane" :
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
In my experience, I've found that enabling full logging for a
short time
(perhaps a few hours) gathers enough data to run through tools like
pgFouine
On Jul 23, 2009, at 10:11 AM, bulk wrote:
I am working for a small company that is going through a PCI DSS
audit.
securitymetrics.com? (They seem to be the low bidder, with everything
that implies. They asked me to open up my firewall to them, pointing
at a fake server, just so they'd ha
On Jul 23, 2009, at 12:11 PM, Steve Atkins wrote:
4) Is is possible to compile C or Java code that will allow me to
be the only one whom knows the pass-key but allow other users to
encrypt/decrypt data?
Yes, that's asymmetric cryptography, using something like DSA.
Oops. Misse
On Aug 4, 2009, at 6:41 PM, Richard Esmonde wrote:
Hi,
I’m new to PostGres (so go easy on my naivety). I am trying to
configure the postgres host based configuration file to permit users
to authenticate against our Active Directory.
Needless to say both Ubuntu server and AD are in the sa
On Aug 17, 2009, at 12:15 PM, Bob Gobeille wrote:
On Aug 17, 2009, at 12:46 PM, Alvaro Herrera wrote:
Bob Gobeille wrote:
I use PSQL to set my editor to vi. This works as expected in psql,
\e brings up vi and I edit away.
Is there any way to set my psql command line editor to also use vi
On Aug 27, 2009, at 1:42 PM, Sergey Samokhin wrote:
Hello.
As I know upgrading database structure from one version to another is
usually done by applying some sql-script with a set of ALTER's that do
all the work.
But how do programmers guarantee that ALTER's they have wrote will
always be ap
On Sep 3, 2009, at 11:30 AM, Mark Lubratt wrote:
Hello!
I've been running the 64-bit version of 8.3.4 on OpenSolaris 2009.06
for over a year. Now, I need to put a perl function call into it to
allow emails to be sent by the database backend. I tried installing
plperl, but it looks like
On Sep 28, 2009, at 9:24 AM, John wrote:
On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote:
2009/9/28 John
Hi,
I have a development DB and a production DB. I need a way to sync
the
changes
I make to the stucture in the devel DB to the production DB. I
found
pgdiff
bu
On Oct 5, 2009, at 8:04 AM, Joshua Berry wrote:
Our shop uses postgres for a dozen installations. The applications
have some realtime performance requirements, and are just good enough
to function properly. The problem is that the clients (owners of the
production servers) are using the same se
On Oct 9, 2009, at 9:46 AM, Scott Ribe wrote:
The range of a twos-complement 32-bit integer is -2147483648 through
2147483647. Yet in Postgres:
# select -2147483647::int4;
?column?
-
-2147483647
(1 row)
# select -2147483648::int4;
ERROR: integer out of range
Is this a bug? Or
If I have a partitioned table that has some range constraints that look kinda
like they're intended for constraint exclusion, but aren't quite
non-overlapping, will that break anything?
e.g.
create table jan ( …, check(created >= '2013-01-01' and created <
'2013-02-01'), check(id >=0 and id
On Sep 6, 2013, at 9:37 PM, François Beausoleil wrote:
>
> Le 2013-09-07 à 00:29, Steve Atkins a écrit :
>
>> If I have a partitioned table that has some range constraints that look
>> kinda like they're intended for constraint exclusion, but aren't quite
>
On Sep 7, 2013, at 7:20 AM, Tom Lane wrote:
> Alban Hertroys writes:
>> On Sep 7, 2013, at 6:54, Steve Atkins wrote:
>>>> If I have a partitioned table that has some range constraints that look
>>>> kinda like they're intended for constraint exclusion,
On Sep 18, 2013, at 7:40 AM, Gordon Ross wrote:
> On the postgresapp.com you can only download the latest version of Postgres
> for the Mac. Is it possible to download a specific version?
There are tagged builds on github -
https://github.com/PostgresApp/PostgresApp/releases
Cheers,
Steve
On Oct 7, 2013, at 2:48 PM, Guy Rouillier wrote:
> We have a fairly large (1 TB) database we put on all SSDs because of a very
> high insert and update rate (). As our business has grown, we've been
> running into space constraints, so we went looking for files we might be able
> to delete.
On Oct 11, 2013, at 8:57 AM, Bret Stern
wrote:
> My interpretation of "Forms these days are written in HTML" means
> most interfaces are web front ends to the cloud. Not a GUI framework.
Yup.
But embedding an HTML renderer in your desktop app does allow you to
use HTML where it's appropriate
On Oct 17, 2013, at 3:13 PM, "Huang, Suya" wrote:
> Hi,
>
> I’ve got a question of converting database from ascii to UTF-8, what’s the
> best approach to do so if the database size is very large? Detailed procedure
> or experience sharing are much appreciated!
>
The answer to that depends
On Dec 9, 2013, at 2:39 AM, Joek Hondius wrote:
> Hi All,
>
> We have been running our product on PostgreSQL for quite some time now.
> Started out with 7.0
>
> I have this situation where i want to migrate my (many) PostgreSQL 8.3
> databases to a new server running 9.2
> In my case this is
On Dec 10, 2013, at 8:47 AM, Wolfgang Keller wrote:
>> http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?
>
>> Synchronous Multimaster Replication
>
> *snip*
>
>> PostgreSQL does not offer this type of replication (...)
>
> Now I compare that statement with:
>
>
On Jan 10, 2014, at 8:35 AM, Preston Hagar wrote:
> tl;dr: Moved from 8.3 to 9.3 and are now getting out of memory errors despite
> the server now having 32 GB instead of 4 GB of RAM and the workload and
> number of clients remaining the same.
>
>
> Details:
>
> We have been using Postgresq
On Jan 14, 2014, at 10:58 AM, John Sutton wrote:
> Hi there
>
> Having spent about 2 hours trying to solve a simple problem, I think it might
> be worthwhile to record my efforts. Perhaps someone can point out how
> extremely silly I have been… or is the documentation lacking?
>
> My origin
On Feb 5, 2014, at 12:50 PM, Eliott wrote:
> Dear community,
>
> I've just noticed that in one of our databases many duplicate tables had
> appeared all ending in _copy. These tables are owned by postgres not the db
> owner user, other than that they seem to be a replica from a specific time
On Feb 11, 2014, at 2:56 PM, Bruce Momjian wrote:
> Someone suggested that 'asciidoc'
> (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format
> for psql, similar to the existing output formats of html, latex, and
> troff.
>
> Would this be useful?
Less so than Markdown[1], IMO.
On Feb 28, 2014, at 2:04 PM, George Weaver wrote:
> Hi list,
>
> I'm stumped.
>
> I am trying to use Regexp_Replace to replace ordinal suffixes in addresses
> (eg have '126th' want '126') for comparison purposes. So far no luck.
>
> I have found that
>
> SELECT REGEXP_REPLACE(LOWER('30
On Feb 28, 2014, at 2:43 PM, George Weaver wrote:
> From: Steve Atkins
>
> >Maybe this?
>
> >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)',
> >'\1', 'gi');
>
> Hi Steve,
>
> Thanks, bu
On Mar 1, 2014, at 11:45 AM, George Weaver wrote:
>
>> Actually, I found that the double backslashes are required whether the E is
>> used or not:
>
>> You must be using a relatively old PG version then. Default behavior
>> since around 9.1 has been that backslashes aren't special except
>> i
On Mar 4, 2014, at 2:19 AM, David Janssens wrote:
> Hello,
> I would like to log statements that modify a small subset of tables in a
> databases.
> (not all tables, because the log files become too big in that case and I also
> worry about performance)
> I currently use log_statement='mod' bu
On Mar 13, 2014, at 12:18 PM, Susan Cassidy
wrote:
> I have a weird issue that I can't figure out.
>
> If I run the exact same query through psql as through perl DBI, I get
> different results. I get far fewer results with DBI than through the psql
> command line.
>
> Any ideas why that wo
On Mar 13, 2014, at 1:20 PM, Susan Cassidy
wrote:
> Yes, I am running with use strict. The statement I pasted in is after perl
> quoting, being written out by the same perl program. I just take that
> statement and paste it into the psql window.
>
> DBI->trace showed nothing out of the ord
On Mar 31, 2014, at 8:08 AM, Rob Sargent wrote:
> I'm angling toward using a very wide char(1) array. Is the one-byte overhead
> for char(n<126) applied to each element or to the array?
Each element, it's a variable length type.
There's probably a better way of storing your data, but if you
On Apr 2, 2014, at 12:37 PM, Rob Sargent wrote:
> I'm playing with various data models to compare performance and
> practicalities and not sure if I should be surprised by the numbers I'm
> getting. I hope this report isn't too wishy-washy for reasoned comment.
>
> One model says a genotype i
On Apr 2, 2014, at 1:14 PM, Rob Sargent wrote:
> On 04/02/2014 01:56 PM, Steve Atkins wrote:
>> On Apr 2, 2014, at 12:37 PM, Rob Sargent
>> wrote:
>>
>>>
>>> Impatience got the better of me and I killed the second COPY. This time it
>
On Apr 9, 2014, at 1:33 PM, Scott Marlowe wrote:
> On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
> wrote:
>> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
>> wrote:
>>> Hi all!
>>>
>>> Does PG perform that much better on FreeBSD? I have some performance issues
>>> on a Ubuntu 12.
On Apr 26, 2011, at 10:24 AM, Carlos Mennens wrote:
> We've been using a Wiki server at the office for years. It was
> originally configured to use MySQL and finally after 8+ years we're
> moving the Wiki to a new platform of hardware. My question is the Wiki
> software (MediaWiki) is the only th
On May 28, 2011, at 7:55 PM, Darren Duncan wrote:
> Does Postgres have any mechanisms where one can set an activity timeout, say
> either dynamically thru SQL to affect a current session, or alternately in a
> configuration file so to take effect globally?
>
> I mean for example so we can tell
On Jun 20, 2011, at 10:49 PM, CSS wrote:
> Hello,
>
> I couldn't find much information in the archives on this -- perhaps this
> is a bit of a specialized need, but I was hoping for some input from
> some experienced postgres admins.
>
> I'm moving some DNS servers from djbdns/tinydns to PowerD
On Jul 17, 2011, at 9:36 PM, AI Rumman wrote:
> Database Version: Postgresql 9.0.1
> OS: Linux rumman.dhaka 2.6.18-92.el5xen #1 SMP Tue Jun 10 19:55:54 EDT 2008
> i686 i686 i386 GNU/Linux
> Installed from: Source configure
> Problem:
> When I try to connect to postgres, I got -
> psql: FATAL: r
On Aug 11, 2011, at 12:34 PM, Rich Shepard wrote:
> On Thu, 11 Aug 2011, Chris Travers wrote:
>
>> The simplest seems to me to be a sequence and use nextval() to populate
>> the null values. The major advantage would be that the sequence could stay
>> around in case you need it again. So for exa
On Aug 16, 2011, at 11:42 AM, John R Pierce wrote:
>
> this whole discussion reminds me of the old adage...
>
>if your only tool is a hammer, every problem looks like a nail.
I'm amazed nobody has mentioned http://www.sqlonrails.org/ yet.
Cheers,
Steve
--
Sent via pgsql-general maili
On Jun 21, 2012, at 8:45 AM, Kris Deugau wrote:
> I'm writing a tool for web-based management of DNS records, and I've
> come up against a UI nuisance that I'm hoping I can get solved in
> Postgres instead of some higher layer.
>
> One table contains all of the live records:
>
> CREATE TABLE re
On Jul 5, 2012, at 2:09 PM, James Hartley wrote:
>
>
> By scouring the table of contents, it appears that these "newer" LITE
> editions are subsets of the older volume. It does not appear that there is
> any new material in these newer offerings.
>
> I am *very* much a fan of Simon Riggs' 201
On Jul 30, 2012, at 7:36 AM, Little, Douglas wrote:
> I have an input source that is in epoch time.Is there a built-in
> conversion to changing to timestamp
to_timestamp().
You can also do things like "select timestamptz 'epoch' + ? * interval '1
second'".
Cheers,
Steve
--
Sent via
On Aug 7, 2012, at 8:41 AM, Aram Fingal wrote:
> I have a field which contains an interval value and I sometimes need to
> represent the full interval (not a part) as a decimal number of months. For
> example, "5 years 6 mons 3 days" as "66.1 months". I've been trying to
> figure out how to
On Aug 31, 2012, at 12:45 PM, Scott Marlowe wrote:
> So do they ever go to a site that ends in .org or .info? Tell them to
> stop it right now, as they are relying on PostgreSQL for those sites
> to resolve, and PostgreSQL is too far out of the mainstream. Once
> they've stopped using or visit
On Aug 31, 2012, at 4:15 PM, Scott Marlowe wrote:
>
> Unless things have changed, Andrew Sullivan in this message
> http://archives.postgresql.org/pgsql-advocacy/2002-09/msg00012.php
> says:
>
> "All interactions with the shared registry system, and any whois
> queries against whois.afilias.net
On Sep 17, 2012, at 11:58 AM, niXman wrote:
> Hello,
>
> Tell me please, whether there is an official C++ API for postgresql?
http://pqxx.org/development/libpqxx/ is the main C++ specific library. But
you can also use libpq from C++, and for simpler work it's often easier
than libpqxx.
There
On Oct 1, 2012, at 10:26 AM, Shaun Thomas wrote:
> On 10/01/2012 12:19 PM, Darren Duncan wrote:
>
>> You should never put your passwords (or private keys) in source control;
>> it would be better to use the puppet/bcfg option.
>
> That was kind of my point. Puppet / Bcfg2 have the same problem
On Apr 24, 2010, at 8:40 AM, John Gage wrote:
> I know this is perhaps an inappropriate question (and to some extent I am
> repeating myself), but I now need to get my website up and running.
>
> Would anyone be willing to suggest an ISP that offers virtual machines
> running postgres and perl
On Apr 27, 2010, at 9:33 AM, akp geek wrote:
> Hi all -
>
> I would like to know, if there is a open source BI tool for
> creating reports against Postgres database ? appreciate your help
Pentaho, BIRT, JasperReports (and associated tools like iReport), JFreeReport,
DataVision, O
On May 7, 2010, at 10:18 AM, Joao Ferreira gmail wrote:
> Hello all,
>
> I need to write an application in C to read the list of databases
> currently in the server. very much like a "psql -l"...
>
> but I need it in C ! I never used C before to access PG.
>
> the libpq API seems a bit scary !
On May 19, 2010, at 10:32 AM, Scot Kreienkamp wrote:
> Hi everyone,
>
> I have a column of type CIDR in a table that I am querying that contains
> the values of 10/8, 10.1/16,10.1.28/24, and 10.1.28.95. I am trying to
> return only the one record that's most specific compared to the IP
> addres
101 - 200 of 422 matches
Mail list logo
