I'll add a routine to stall the standby backup until the
restartpoint corresponding to the pg_start_backup has been replayed. I'll see
if that helps.
Thanks!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd | Suite 500 | Chicago IL, 60
gt; file you would not be able to restore the data.
I suppose I could build in a function to pause the backup until the
restartpoint replays on the replica. Then at least, the backup "starts"
on both systems with the same assumptions.
--
Shaun Thomas
OptionsHouse | 141 W
hard links to save
space. I can back up a 800GB database in less than 20 minutes a night, or 45
minutes for a non-incremental backup. Without disturbing the primary node. Like
I said, I can enable filesystem snapshots to fix this, but it feels like
something more obvious is going on.
Any ideas?
subsequent
triggers are not fired, and the INSERT/UPDATE/DELETE does not occur for
this row)"
You could also raise an explicit error so the user sees something. To
fake a foreign key violation, you'd do:
RAISE EXCEPTION foreign_key_violation;
So you don't need a rollback anyway.
--
Gauthier, Dave wrote on 08.10.2013 20:27:
Someone is asking me for a way to architect a model which will store
basic table data (columns with names and rows), but the number and
name of the columns are both variables. I'll call these
"data-tables" here.
sounds like the hstore extension could
, if you have a
workload which triggers these issues, the workaround is to schedule
ANALYZE jobs.
Thanks Kevin, that explanation totally makes sense. I can switch to a
separate VACUUM and ANALYZE step to avoid this until the fix comes through.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd
essage?
This all seems a little sketchy.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to
e attempt though. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to
this email
--
Sent
exclusion checks.
My guess based on the fact the planner has no concept of ranges aside
from their width, is that this is the approach it'll likely take. You
can't really teach it that your particular inheritance tree is range
constrained per level, so it has to check every rang
estimated partitions.
However you decide to do it, don't optimize prematurely. Monthly
partitions are enough for us and our 130GB table with 250M rows, and
that's for a single year.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago I
quote_ident(tablename);
END LOOP;
END;
$$ LANGUAGE plpgsql;
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and con
Patrick Dung wrote on 13.09.2013 18:17:
The problem of pg_upgrade is that it needed to hold two set of databases data
in the server.
This is not be desirable (very slow) or possible (space limitation) for
database with huge data.
For example, if the old version is already using over 50% of the
Patrick Dung wrote on 12.09.2013 18:11:
For PostgreSQL, it seems I can't find the list (it just say see the
Appendix E / release notes). I think it is a plus for PostgreSQL if
it has few incompatibilities between major versions.
There is such a list in the release notes:
http://www.postgresql.
Merlin Moncure wrote on 12.09.2013 18:37:
By the way, for in-place major version upgrade (not dumping DB and
import again), MySQL is doing a better job in here.
http://www.postgresql.org/docs/9.3/static/pgupgrade.html
pgupgrade has nothing to do with this: that's just a tool that does in
plac
On 9/3/2013 6:08 PM, Andreas 'ads' Scherbaum wrote:
PostgreSQL folks!
We are looking for the next big thing. Actually, it's a bit smaller: a
new design for mugs. So far we had big blue elephants, small blue
elephants, frosty elephants, white SQL code on black mugs ... Now it's
time to design so
Hy folks,
I'm trying to migrate a database running on mysql for the famous
www.redmine.org from mysql to postgresql.
I was looking for ressources and I found this :
http://www.olimpiks.ru/2011/03/redmine-mysqlpostgresql-converter.html
The process is almost perfect except for the binary datas.
_ctl and send a reload command.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to
this email
--
Sent
eter:
sudo -u postgres psql -d mydb --file=/home/user/dev/mydb_create.sql
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ess. I always use ProcessExplorer (or ProcessExplorer, both from
www.sysinternals.com - now Microsoft) to be indispensable to figure out which
process is locking a file.
> I realise Thomas at least will frown most deeply at these ‘operations’,
> though they often work as a low-tech s
hidayat...@gmail.com, 31.07.2013 15:52:
> As per my experience, installing postgresql on windows machine
> automatically create postgres user. When you uninstall it, the
> postgres user doesn't automatically removed, you must remove it
> manually.
Not any more.
Since 9.1 (or was it 9.2?) Postgre
ry named log.
It's in a directory named pg_log in the *data* directory, not the installation
directory
The relevant line in the installer log is:
processed file: D:\_SDB\Database\RDBMS\PostgreSQL\9.2\data\pg_log
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@p
t empty, causing me to use the above
workaround to copy back my data afterwards. Should be able to do
this!
Again: the upgrade process is clearly documented in the manual.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John R Pierce, 18.07.2013 21:20:
>> If you want to install a completely new instance, just put it into
>> a different directory, and given the service a different name.
>>
>> Newer Postgres versions don't need a dedicated Windows user account
>> any more.
>>
>> I usually don't use the installer a
Joe Van Dyk wrote on 18.07.2013 23:23:
Will the custom worker support in 9.3 let me put cron-like tasks into
postgresql?
I have a lot of database functions that should run every few seconds,
every minute, every hour, once a week, etc. Right now, I always have
to have exactly one machine setup wi
Arvind Singh wrote on 18.07.2013 12:22:
I want to install postgresql for use as the backend to a Windows application.
This seems to be no problem if postgresql is NOT already installed on the
system. which is not in this case.
postgresql is already installed and unless the command line parame
tgreSQL seems to prefer this index over other indexes.
Is there any way to increase the cost for this specific index (or operator) so
that any other index is always used first?
Beat Regards,
Thomas
John Smith wrote on 17.07.2013 22:39:
guys,
have to use legacy 8.1.
i have 100,000 tables in a schema that need to be queried (optimizing this by
combining them into one will have to wait).
so my query goes like so:
> execute 'select * from ' || tabname::regclass || ' where firstname = "joh
Thomas Kellerer, 05.07.2013 13:46:
> Postgres 9.3 will add "event triggers", but they can only be written in SQL
That should have been: "only C and procedural languages like PL/pgSQL"
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
itishree sukla, 05.07.2013 10:29:
> Hello Every one,
>
> Is Postgresql providing triggers on DB level, schema level ( in same DB)?
>
You are probably referring to "DDL" triggers and similar things (a trigger when
a table is created or dropped, a user logs in and so on).
The answer is no as far
fixed our particular case was this one:
http://www.postgresql.org/message-id/50e4aab1.9040...@optionshouse.com
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www
function.
How can I migrate this function into PostgreSQL with above mention criteria.
Hi,
as i know each value is limited to 1GB. For larger content use module lo
http://www.postgresql.org/docs/9.2/static/lo.html
Thomas
Kevin Grittner wrote on 10.06.2013 15:19:
It has nothing to do with the way you are using the cursor; your
problem is that you are causing an error by attempting to COMMIT
inside a function (which is not allowed). This rolls back the
subtransaction defined by the BEGIN/EXCEPTION block. You then
true
The Liquibase changelog files are then stored in Subversion.
A little shell script applies the changes to any environment we want
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to automate the migration.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
behind, it can
always catch up again.
Honestly in sync rep, I'm surprised the master doesn't keep segments
until a waiting slave either disconnects, or can consume WAL files being
held up by a long-running transaction. Not that it matters, since you
can fake that behavior th
er_3 might only have management,orders
Once the search paths are properly defined no prefixing is necessary and you'd
have the same situation as with Oracle synonyms.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
system peaks at 18k TPS
and handles roughly a billion queries per day.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms
t a much faster result. That would also allow you to drop
history_creator_index. Since history_lookup_lookupid_index covers the
same first two columns, you shouldn't lose anything in queries that work
better with those in the front.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. |
Tom Lane wrote on 16.05.2013 19:36:
As the materialized view should be a "table" that can be selected from, I
wonder what the purpose of the rewrite rule is?
To store the matview's definition for use in REFRESH.
Ah, right. Makes sense.
Thanks for the quick reply.
--
Sent via pgsql-gene
is:
REATE RULE "_RETURN" AS
ON SELECT TO matview_test DO INSTEAD
SELECT
As the materialized view should be a "table" that can be selected from, I
wonder what the purpose of the rewrite rule is?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general
have udev
installed. You *could* put blockdev calls in /etc/rc.local I suppose,
but udev applies rules at device detection, which can be beneficial.
I assume both. I should ask the same for noatime advice while I'm at
it.
You can probably get away with relatime, which is the default for
re several examples out there:
http://www.xzilla.net/blog/2011/Mar/Upserting-via-Writeable-CTE.html
http://www.depesz.com/2011/03/16/waiting-for-9-1-writable-cte/
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
http://stackoverflow.com/a/8702291/330315
Regards
Thomas
--
Sent
ytea only, it does not support "large objects" but as you are
storing "small images", bytea is the better choice anyway.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a2.procpid = l2.pid)
WHERE l1.granted
AND NOT l2.granted;
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions re
's because of the statement that you see when you
cancel. Something tells me that if you try this again, it'll be the same
foreign key check.
Look and make sure account_id in ibmgbs_values is the same exact type as
the referenced table.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson
listed column, and it's the same datatype (bigint). Otherwise, this is
going to take a long, long time.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak
eing added
to the test. Regular reviews are also necessary to catch questions that
become invalid with new PG releases.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See ht
cost, but that was back on kernel 3.2.31, so maybe that'll change.
Thanks for the info!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_
x27;t help, say something. The more examples we get of edge cases
confusing the planner, the quicker they'll get addressed.
This is an awesome little test case, though. How dramatically it
explodes really is something to behold.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd.
code = 'AMA'::text))
These are pretty drastically different. But... the first crippled my
test system and started consuming vast resources, while the second
executed in about 300ms. That's hard to believe with the row counts seen
here unless it's turning it into some invisib
Simon Riggs, 28.04.2013 21:42:
On 21 April 2013 12:17, Thomas Kellerer wrote:
DB2 lets you define your own types (just as Postgres) but with the added
benefit that you can mark them such that they are _not_ comparable, e.g. to
avoid comparing "apples to oranges".
Sounds like an i
always comes first, and eliminates other candidates.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions re
Abhinav Dwivedi wrote on 22.04.2013 07:12:
select * from district where statecode in (Select districtcode from state)
Please note that the attribute districtcode is not existent in the table state
and
if this query i.e. Select districtcode from state is executed in isolation then
it
correctly
ved smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
-- WAL 00020037 archived --
Btw, my archive_command was archive_command = 'cp -i %p
/home/thomas/postgresql/v92/archives2/%f http://www.postgresql.org/mailpref/pgsql-general
t get much better constructive
feedback.
It does sound nice.
I'm more interested if this can be dealt with on SQL level, rather than hacking
Postgres itself
(and it's not really a "request" for a new feature - I'm just curious)
Thomas
Sent from my Thunderbird
--
lude comparison functions, I have
the feeling that this should be possible, but I don't have an idea on how to
start to be honest.
Any ideas?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
On 19 March 2013 01:00, Tom Lane wrote:
> Wasim Arif writes:
> > What is the road map for Postgres on the AIX platform? I understand that
> > the pg build farm contains an AIX 5.3 server; are there any plans to
> > upgrade to 6.1 and 7.1?
>
> The reason there's an AIX 5.3 buildfarm member is tha
.
You should still upgrade those, of course, but it shouldn't cause problems.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer
the problems in 8.3.
http://bonesmoses.org/2010/06/03/why-i-married-pg_migrator/
It worked way back then for the company I was working for at the time.
Could work again. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
7;t care how long it takes, you can replace lzop with lbzip2 or
something you can use in parallel. This will take 4-8x longer, but can
use up to 30% less bandwidth based on tests I've run.
Otherwise, I'd recommend just using pg_basebackup.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson
John R Pierce wrote on 10.04.2013 21:28:
On 4/10/2013 6:15 AM, Thomas Kellerer wrote:
psql (one of the possible client applications) uses the "datestyle"
parameter to decide on how to format a date column when displaying
it.
If you change the "datestyle" parameter in post
can be indexed.
Of course, you have to install it first. Take a look here:
http://www.postgresql.org/docs/8.4/static/pgstatstatements.html
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
"datestyle" parameter
to decide on how to format a date column when displaying it.
If you change the "datestyle" parameter in postgresql.conf, it will influence
the way psql displays the date values. Probably pgAdmin will also check that setting (as
I don't use pgAdmin I can&
lpful.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
good.
I have read about using pg_basebackup in an article from Shaun
Thomas' booklet on Packt Publishers**(I will probably buy the
booklet)*. *That seems to be a possible solution.
Ok, with pg_basebackup, you'll get a binary backup of the actual data
files involved in your databa
everything at once. That's not always an option for
everyone though. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer
epub, but there ya go.
Maybe it takes a while to associate them.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and
On 04/03/2013 12:49 PM, Igor Neyman wrote:
Is there plans for e-book edition?
I believe there already is one. Packt sells it directly, and it's also
listed on Amazon. Way cheaper than the print version, I think. About
five bucks, as opposed to 20.
--
Shaun Thomas
OptionsHouse |
exactly Greg Smith's performance book, but I'm glad to
contribute how I can. I'm not entirely sure it's worth adding to the
book page:
http://www.postgresql.org/docs/books/
But if it is, I'll provide any help or extra information necessary. If
anyone has questions,
On 28 March 2013 13:52, Shaun Thomas wrote:
> On 03/28/2013 07:43 AM, Gavan Schneider wrote:
>
> Personally I have ignored the money type in favour of numeric. Money
>> seemed to do too much behind the scenes for my taste, but, that's me
>> being lazy as well, I have
ould still be useless for calculations in applications requiring more
significant figures, but would make more sense than the currently
magically morphing value it is now.
"Hey, we just shipped a DB server to Japan, and now all of the monetary
values are wrong. WTF!"
Yeah... no.
tremely happy to see the recent improvements in numeric performance
that seem to be coming in 9.3. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/emai
.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane, 26.03.2013 17:16:
The lack of any prohibition to the contrary means there is no way to
argue that the code you showed previously violates the spec; thus,
a database that fails to accept it is rejecting spec-compliant DDL.
I'm not claiming that the spec is violated...
(And I'm not comp
y it simply doesn't make sense, does it?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Is there a technical reason, or is it simply a matter of "no one cared enough to
change this"?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ation system. In the
end, we regained about 50GB of "phantom" space after a re-mount, and
it's stayed that way since.
But that's what du --apparent-size is for. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
Achilleas Mantzios wrote:
> On Ôåô 20 Ìáñ 2013 15:15:23 Dan Thomas wrote:
>
>>
>> We actually have another FreeBSD8.3/PG9.1 machine under different (but
>> similar) load that *doesn't* demonstrate this behaviour. There's
>> nothing obvious in the difference
behaviour. There's
nothing obvious in the differences in usage patterns that we can see
(we're not using any exotic features or anything), but it certainly
suggests that it's *something* related to PG or our usage of it.
On 20 March 2013 14:11, Vick Khera wrote:
>
> On Wed, M
You could use e.g. contig[1] from SysInternals to de-fragment the data files
and then check if that really improves performance.
Thomas
[1] http://technet.microsoft.com/de-de/sysinternals/bb897428
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
sed problem and after the reboot
> and make a diff of those
>
> to fimd any invlolved files/dirs?
>
> That said, i think you might consider posting on freebsd-[questions|stable]
> as well.
>
>
>
> On Τετ 20 Μαρ 2013 11:49:07 Dan Thomas wrote:
>
> Hi Guys,
>
>
Hi Guys,
We're seeing a problem with some of our FreeBSD/PostgreSQL servers
"leaking" quite significant amounts of disk space:
> df -h /usr/local/pgsql/
Filesystem SizeUsed Avail Capacity Mounted on
/dev/mfid1s1d1.1T772G222G78%/usr/local/pgsql
> d
u clearly have some perspective I don't. From where I'm
sitting though, I don't get the barely suppressed rage. ;)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
_
Kevin Grittner, 15.03.2013 14:36:
I occasionally hear someone maintaining that having a meaningless
sequential ID column as the primary key of each table is required
by the relational model. At those moments I swear I can actually
hear E.F. Codd turning in his grave. It was a requirement of ol
On 03/13/2013 10:30 AM, Greg Jaskiewicz wrote:
Is that SSD mixed in with other disks?
Kinda. We chose a PCIe-based SSD (FusionIO). We have a RAID-10 for
low-transaction and archived data.
It worked for us, but it's pretty spendy.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. |
NVRAM (SSD) for high TPS data, and creating a tablespace on
a RAID-10 for archived or low-priority data.
But we got by on those original 12 spindles for a couple years. If your
data needs are less, you can probably do OK with six. For a while,
anyway. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jac
functions (pg_get_viewdef,
pg_get_functiondef, ...)
I would make sense to have one for tables as well.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
atest is 9.1.8, that might be it.
It would explain why my contrived scenario in stage couldn't replicate
it, too. I'm going to see if I can trigger this behavior in stage by
creating a bunch of dead tuples in the slony log table while it's working.
Thanks, Kevin!
--
Shaun Thomas
at broke it or why it was acting that way when that
clearly isn't the design goal.
Ah well.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/e
l pretty much have to drop Slony then. I just
want to keep it working until then. :)
Thanks for the info!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.p
ws would be terrible with
this design.
I plan on asking the slony guys too, but I figured someone on this list
might happen to know.
Looks like I might have to look into Bucardo or Londiste.
Thanks!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 606
ut it seems this
still isn't fixed.
I'm only using the ZIP distribution - amongst other reasons also because of
this problem.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ve" but I can't find
anything on how to do this.
(Note: I'm not very experienced with Linux so I wouldn't be surprised if I'm
missing something very obvious).
Thanks
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Satoshi Nagayasu, 17.02.2013 17:42:
I have never seen InstantSQL itself, but I had chances several times
to go the RDB technical seminars here in Japan, where I have found
that learning database technology is really exciting. :)
So, I wish I will be able to work with RDB (and VMS) someday. :)
Gauthier, Dave wrote on 16.02.2013 17:04:
Many, many (many) years ago, while working at DIGITAL EQUIPMENT
(before it bellied up), I worked with a relational DB they created
called "RDB".
RDB/VMS was actually the first relational database I ever worked with.
Boy, is that a long time ago...
Frank Lanitz, 12.02.2013 11:01:
It's more like a question of best practice:
How do you managing different version of database layout for e.g.
software releases?
We are planing to do an application based on postgres and want to store
some version number of database layout to ensure correct upgrade
'm not mistaken (because the FK value needs to be stored somewhere in order to be
able to look it up).
So I think exposing the ability to declare a virtual column would open up even
more possibilities (and then in turn allow those virtual columns to be used in
a FK constraint).
Thomas
--
. :)
Thanks, again!
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
__
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to
this email
--
Sent via pgsql-
to forward to AD), and that works graet, but has the same
problem. If the user is presented with a PW prompt more than once in a
row, something has failed.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
stho...@optionshouse.com
___
n the admin team brought up Kerberos as a way to let the
underlying system punt through to the LDAP server, so we're
investigating that instead. If we then strongly encourage people to not
use .pgpass and just let kerberos cache their credentials, that should
take care of it. Maybe.
--
Sha
401 - 500 of 1881 matches
Mail list logo