I am using postgresql 9.3 with pgadmin III, and Access 2013 as a front end
for data entry using (ODBC connection) linked tables, on a Windows 8.1 (64).
I have one main database I am developing on a localhost:5432, with four
other test databases I had on the same localhost. A few weeks ago the four
On 4 August 2015 at 17:02, Adrian Klaver wrote:
> On 08/04/2015 07:48 AM, Killian Driscoll wrote:
>
> CCing list
>
> FYI, I will be away from my computer. Someone else will have to follow up
> to my questions below.
>
>>
>>
> So that is not the server you
I am using postgresql 9.3 on Windows 8 64, and am using Access as a
frontend data entry. In postgresql I have changed the schema from 'public'
to 'irll'. The linked table in Access are still linked as 'public' and I
need to update/change the connection of the tables to match the new schema
in the p
I have a view with 15 columns and want to create another view based on a
join with another table with 15 columns that includes three columns that
reference one lookup table.
If I use the the below sql I get the error "column "macro_lookup_id"
specified more than once". I have read that I can renam
On 17 November 2015 at 16:10, Killian Driscoll
wrote:
> I have a view with 15 columns and want to create another view based on a
> join with another table with 15 columns that includes three columns that
> reference one lookup table.
>
> If I use the the below sql I get th
> >
> > In terms of database structure and typing efficiency, it might be better
> > to restructure the lookup tables and create a new lookup table for each
> > of the three columns instead of one combined one?
>
> [Please keep you replies on-list - thanks!]
>
Sorry! Didn't mean that
>
> You'
I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and
postgreSQL 9.4 on port 5532 with the latter set up to use with Bitnami
stack to test php files I am generating from my db.
I want to transfer my db with three schemas from port 5432 to port 5532 to
use within the bitnami stack. I ha
how to do it via an export and import.
>
>
> Bye
>
> Charles
>
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Killian Driscoll
> *Sent:* Mittwoch, 23. Dezember 2015 09:58
> *To:* pgsql-gener
On 23 December 2015 at 10:29, Andreas Kretschmer
wrote:
> Killian Driscoll wrote:
>
> > I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and
> postgreSQL
> > 9.4 on port 5532 with the latter set up to use with Bitnami stack to
> test php
> > fi
On 23 December 2015 at 10:58, Charles Clavadetscher <
clavadetsc...@swisspug.org> wrote:
> Hello Killian
>
> >> I want to transfer my db with three schemas from port 5432 to port 5532
> to use
> >> within the bitnami stack. I have used pgAdmin to create a backup.sql
> and when
> >> using pgAdmin t
On 23 December 2015 at 11:07, John R Pierce wrote:
> On 12/23/2015 1:40 AM, Killian Driscoll wrote:
>
> Try it with plain pg_dump.
>>
>> pg_dump -h localhost -p 5432 -Fc > dump.sql
>>
>> pg_restore -h localhost -p 5532 dump.sql
>>
>
> I tried t
On 23 December 2015 at 11:19, Killian Driscoll
wrote:
> On 23 December 2015 at 11:07, John R Pierce wrote:
>
>> On 12/23/2015 1:40 AM, Killian Driscoll wrote:
>>
>> Try it with plain pg_dump.
>>>
>>> pg_dump -h localhost -p 5432 -Fc > dump.sql
>
On 23 December 2015 at 11:36, John R Pierce wrote:
> On 12/23/2015 2:25 AM, Killian Driscoll wrote:
>
> Sorry, forgot to add: once I get the warning that the Pg_dump can't be
> found there is then a password prompt; I tried the db password and the pc
> password but bot
On 23 December 2015 at 14:56, Adrian Klaver
wrote:
> On 12/23/2015 03:43 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 11:36, John R Pierce > <mailto:pie...@hogranch.com>> wrote:
>>
>> On 12/23/2015 2:25 AM, Killian Driscoll wrote:
>>
&g
On 23 December 2015 at 15:30, Adrian Klaver
wrote:
> On 12/23/2015 06:13 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 14:56, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>>
>> On 12/23/2015 03:43 AM, Killian Driscoll wrote:
>&g
On 23 December 2015 at 15:47, Adrian Klaver
wrote:
> On 12/23/2015 06:35 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 15:30, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>>
>> On 12/23/2015 06:13 AM, Killian Driscoll wrote:
>&g
On 23 December 2015 at 16:02, Adrian Klaver
wrote:
> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 15:47, Adrian Klaver >
>
>
>> So cd into:
>>
>> C:\Program Files\PostgreSQL\9.3\bin
>>
>&g
On 23 December 2015 at 20:07, Adrian Klaver
wrote:
> On 12/23/2015 11:03 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 16:02, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>>
>> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>&g
On 23 December 2015 at 20:14, Adrian Klaver
wrote:
> On 12/23/2015 11:09 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 20:07, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>>
>> On 12/23/2015 11:03 AM, Killian Driscoll wrote:
>&g
ation
> FROM pg_stat_activity
> WHERE pg_backend_pid() <> pid
> ORDER BY datname,
> query_start;
>
>
> On Wed, Dec 23, 2015 at 2:14 PM, Adrian Klaver
> wrote:
>
>> On 12/23/2015 11:09 AM, Killian Driscoll wrote:
>>
>>> On 23 Decem
On 23 December 2015 at 20:24, Adrian Klaver
wrote:
> On 12/23/2015 11:17 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 20:14, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>>
>
>
>
>>
>> So how are you determining it
On 23 December 2015 at 20:26, Melvin Davidson wrote:
> Do not stop the active restore.
> Just run psql from the command shell in the Bitnami binary directory and
> use -U postgres and -p 5532 flags.
>
>
> On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll <
> killiand
he restore
> completed), you should be fine.
> It's usually located in\data\pg_log
>
OK - I see the logs there - the last log was almost 12 hrs ago, so no
recent one.
>
> On Wed, Dec 23, 2015 at 2:27 PM, Killian Driscoll <
> killiandrisc...@gmail.com> wrote:
>
>
part being similar to the alphanumeric I see currently
running in the windows shell. This is all a bit above my pay grade as
you've probably gathered
>
> On Wed, Dec 23, 2015 at 2:50 PM, Killian Driscoll <
> killiandrisc...@gmail.com> wrote:
>
>> On 23 December
On 23 December 2015 at 21:06, Killian Driscoll
wrote:
> On 23 December 2015 at 20:59, Melvin Davidson
> wrote:
>
>> >OK - I see the logs there - the last log was almost 12 hrs ago, so no
>> recent one.
>>
>> That's not very helpful. Depending on how you
On 24 December 2015 at 18:33, Adrian Klaver
wrote:
> On 12/24/2015 12:03 AM, Killian Driscoll wrote:
>
>
>>
>> yeah, this one from Adrian, at 7:02am PST (Z-0800) this
>> morning
>>
>> Per previous posts you want, whenever possibl
26 matches
Mail list logo
